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)

303567Jul 20 2002

Hi all!
What does TRUNC(SYSDATE) do?

I didn't find any difference when I executed the following queries.

1.

SQL> SELECT SYSDATE FROM dual;

SYSDATE
-----------------------
20-JUL-2002 10:12:35 PM

2.

SQL> edit
Wrote file afiedt.buf

1* SELECT TRUNC(SYSDATE) FROM dual
SQL> /

TRUNC(SYSDATE)
-----------------------
20-JUL-2002 12:00:00 AM

Please help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 19 2002

Added on Jul 20 2002

3 comments

55,571 views