TO_CHAR(SYSDATE, 'MONTH DD, YYYY, HH24:MI:SS') : Date Type Convert « SQL Data Types « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL Data Types
  3. Date Type Convert

The following example gets the current date and time from the database using the SYSDATE function.

Converts it to a string using TO_CHAR() with the format MONTH DD, YYYY, HH24:MI:SS.

The time portion of this format indicates that the hours are in 24-hour format.

SQL>
SQL> SELECT TO_CHAR(SYSDATE, 'MONTH DD, YYYY, HH24:MI:SS')
  2  FROM dual;

TO_CHAR(SYSDATE,'MONTHDD,YYY
----------------------------
MAY       30, 2007, 21:29:42

SQL>








10.8.Date Type Convert
10.8.1.Converting Datetimes Using TO_CHAR() and TO DATE()
10.8.2.Using TO_CHAR() to Convert a Datetime to a String
10.8.3.TO_CHAR(SYSDATE, 'MONTH DD, YYYY, HH24:MI:SS')
10.8.4.SELECT TO_DATE('7.4.06', 'MM.DD.YY')
10.8.5.SELECT TO_DATE('July 4, 2006', 'MONTH DD, YYYY')
10.8.6.TO_CHAR() with select statement
10.8.7.Converting a Number Representation to DATE Format
10.8.8.Converting a Spelled Date to DATE Format
10.8.9.Proper Use of the Default Format Mask
10.8.10.(sysdate-start_date)/365