Skip to Main Content

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!

select sysdate from dual (to custom format).

79690Jan 8 2003 — edited Jan 8 2003
Dear all,
i like to SELECT SYSDATE FROM DUAL, and run this result in a query something like:

SELECT X, Y, Z FROM TABLENAME WHERE ACCESSDATE = (SELECT SYSDATE FROM DUAL);

The problem is that the value of ACCESSDATE is in an format like DD-MM-YYYY and that sysdate form dual is
DD-MON-YYYY.

How do i get sysdate into the format DD-MM-YYYY?

Thanks already,
Johan.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2003
Added on Jan 8 2003
9 comments
3,463 views