select sysdate from dual (to custom format).
79690Jan 8 2003 — edited Jan 8 2003Dear 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.