Date Functions: Current Date

Description:

CURRENT_DATE
SYSDATE
 
SELECT TO_CHAR(CURRENT_DATE, 'DD-MON-YYYY HH:MI:SS') FROM dual;
 
SELECT TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS') FROM dual;
 
DATE FORMATS
---------------------------------------------------
DAY      MONTH      YEAR      Fill MODE   Julian DATE
---------------------------------------------------
D        MM          YY          FM           J
DD       MON         YYYY
DDTH                 RR
DAY                  RRRR

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.