Format current system date: 'dd Mon, yyyy hh24:mi:ss' : TO_Char Date « Data Type « Oracle PL / SQL






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