In this article we wre going write a query to get full name of tomorrow. See the below query.

Query:

SELECT TO_CHAR( TRUNC(SYSDATE +1),’DAY’) DAY_IN_WEEK FROM DUAL ;

Output :

TODAY
MONDAY     


See the above output , trailing spaces are there . ‘DAY’ format contains trailing spaces . To remove trailing spaces use ‘FMDAY’ format.