SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

trunc(sysdate)

RobeenFeb 19 2020 — edited Feb 28 2020

Oracle DB 12c

Hello Team,

I would like to know why

SQL> SELECT TRUNC(SYSDATE,'YEAR') FROM DUAL;

returns '01-JAN-20'?

TRUNC(SYS

---------

01-JAN-20

Regards,

Joe

This post has been answered by BluShadow on Feb 19 2020

Jump to Answer

Added on Feb 19 2020

5 comments

2,213 views