SELECT SYSDATE FROM dual;
-- Example syntax used with TO_CHAR and a format mask:
SELECT TO_CHAR(SYSDATE, <format mask>) FROM DUAL;
SELECT TO_CHAR(SYSDATE,'DDD')"Today" FROM DUAL;
Format Mask Definitions:
- D: Day of the week
- DD: Day of the month
- DDD: Numerical day of the year, 1 ~ 365 (366 for Leap years)
- DAY: Full textual representation of the day, i.e. "Monday", "Tuesday", "Wednesday"
- DY: Day in three letters, i.e. "MON", "TUE", "FRI"
- W: Week of the month
- WW: Week of the year
- MM: Month in two digits, i.e. 01 = Jan, 02 = Feb,...12 = -Dec
- MON: Month in three characters, i.e. "Jan", "Feb", "Apr"
- MONTH: Full textual representation of the Month, i.e. "January", "February", "April"
- RM: Month in Roman Characters (I-XII, I-Jan, II-Feb,...XII-Dec)
- Q: Quarter of the Month
- YY: Last two digits of the year.
- YYYY: Full year
- YEAR: Year in words like "Nineteen Eighty Seven"
- HH: Hours in 12 hour format
- HH12: Hours in 12 hour format
- HH24: Hours in 24 hour format ("military time")
- MI: Minutes
- SS: Seconds
- FF: Fractional Seconds
- SSSSS: Milliseconds
- J: Julian Day i.e Days since 1-Jan-4712BC to till-date
- RR: If the year is less than 50 then Oracle considers the year
as a 21st century date. If the year is greater than 50 then Oracle
considers the year to be in the 20th century