Converting Datetimes Using TO_CHAR() and TO DATE() : Date Type Convert « SQL Data Types « Oracle PL/SQL Tutorial






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

TO_CHAR() and TO_DATE() Conversion Functions

FunctionDescription
TO_CHAR(x [, format])Converts the number or datetime x to a string. You can also supply an optional format for x.
TO_DATE(x [, format])Converts the string x to a DATE.










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