In this article we wre going write a query to get full name of tomorrow. See the below query.
Query:
Output :
See the above output , trailing spaces are there . ‘DAY’ format contains trailing spaces . To remove trailing spaces use ‘FMDAY’ format.
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.