Oracle Date format Conversion to_date ()

The most significant relationship with the date operation is two conversion functions: To_date (), To_char ()
The To_date () function converts a character type to a date type in a certain format:
Specific usage: to_date (' 2004-11-27 ', ' yyyy-mm-dd '), the former is a string, the latter is a conversion date format, note that before and after the two to a corresponding.
such as; To_date (' 2004-11-27 13:34:43 ', ' yyyy-mm-dd hh24:mi:ss ') will get specific time

Multiple date formats:

YYYY: Year four-bit representation
Yyy,yy,y: The last three, two, or a bit of the year, the default is the current century
Month Number of mm:01~12
Month: Nine characters in months, and the right is filled with a space
MON: three-character month abbreviation
WW: The week of the year
D: The day of the week
DD: The day ordinal of the month
DDD: The first day of the year
Day: Nine characters full name, right with space
Hh,hh12: The first hour of the day, 12 binary notation
HH24: The first hour of the day, the value is 00~23
MI: Minutes in an hour
SS: seconds in one minute
SSSS: The number of seconds to go from midnight

Oracle Date format Conversion to_date ()