Format current system date: 'dd Mon, yyyy hh24:mi:ss'
SQL>
SQL> SELECT TO_CHAR(SYSDATE, 'dd Mon, yyyy hh24:mi:ss') FROM dual;
TO_CHAR(SYSDATE,'DDMO
---------------------
30 Aug, 2006 19:57:11
SQL>
Related examples in the same category
1. | Converting DATE to spelled-out character format | | |
2. | TO_CHAR(Date, 'Mon') | | |
3. | TO_CHAR(Date, 'Month') | | |
4. | TO_CHAR(Date, 'YYYY') | | |
5. | TO_CHAR(Date, 'MM') | | |
6. | TO_CHAR(Date, 'Year') | | |
7. | TO_CHAR(Date, 'Day') | | |
8. | TO_CHAR(Date, 'DY') | | |
9. | TO_CHAR(Date, 'Q') | | |
10. | TO_CHAR(Date,'DAY MONTH DD, YYYY') | | |
11. | TO_CHAR(Date,'fmDay Month fmDD, YYYY'): Embedded spaces can be removed by placing the 'fm' prefix | | |
12. | TO_CHAR(Start_Date, 'DD, MM, Mon, Month, YYYY, Year, Day, DY, Q') | | |
13. | Suffix 'sp': spell out a numeric value | | |
14. | 'th' suffix: add an ordinal ending to a numeric format element | | |
15. | The TO_DATE function in where clause | | |