[Turn]mysql To_char () to_date () method similar to Oracle

MySQL date and Character conversion method

Date_format (date, '%y-%m-%d ')--------------To_char () in >oracle;

Str_to_date (date, '%y-%m-%d ')--------------to_date () in >oracle;

%Y: Represents a 4-digit year

%y: Represents the year of 2

%m: Represents the month, in the form of (01 ... 12)

%c: Represents the month in the format of (1 ... 12)

%d: Represents the number of days in the month in the format (00 ...). 31)

%e: Represents the number of days in the month in the format (0 ...). 31)

%H: Represents the hour, in the form of (00 ... 23)

%k: Represents the hour, in the form of (0 ... 23)

%h: Represents the hour, in the form of (01 ... 12)

%I: Represents the hour, in the form of (01 ... 12)

%l: Represents the hour, in the form of (1 ... 12)

%i: Represents minutes, in the form of (00 ... 59)

%r: Represents the time, in the format of 12 hours (Hh:mm:ss [ap]m)

%T: Represents the time, in the format of 24 hours (HH:MM:SS)

%s: represents seconds in the format (00 ...). 59)

%s: represents seconds in the format (00 ...). 59)

[Turn]mysql To_char () to_date () method similar to Oracle