Date Conversion Functions in Oracle

To_date

To_date (Char[,fmt[nlsparams])

Char: the string to convert

FMT: Format

Nlsparams: Specifying a Date language

For example: Enquiries about employees who have entered the workforce after 2002 years:

SELECT * from emp where hiredate>to_date (' 2002-01-01 ', ' yyyy-mm-dd ');

Common date formats are shown in the following table:

Yy:2-digit year

Yyyy:4-digit year

Mm:2 Digit Month

MON: The month of simple spelling

Month: All-spell months

Dd:2 digits of the day

DY: Abbreviation of the week

Day: A full spell of the week

Hh24:24 hour time

Hh12:12 hour time

MI: Show Seconds

SS: Show Seconds

Date Conversion Functions in Oracle