Format MySQL timestamp function from_unixtime

I have not studied MySql in depth and have little basic knowledge. I can only use a manual when I encounter any problems. It seems that I have to arrange MySQL learning into a timetable.

Function: from_unixtime
Purpose: display the time stored in int (11) in MySQL in the "YYYY-MM-DD" format.
Syntax:From_unixtime (unix_timestamp, Format)

Returns a string representing the Unix time mark, formatted according to the format string. Format can contain the same modifier as the entries listed by the date_format () function.

Format the date value based on the format string.
The following modifiers can be used in a format string:

% M month name (January ...... December)
% W name of the Week (Sunday ...... Saturday)
% D indicates the date of the month with an English prefix (1st, 2nd, 3rd, and so on .)
% Y year, number, 4 digits
% Y year, number, 2 digits
% A abbreviated name of the Week (Sun ...... Sat)
% D number of days in the month (00 ...... 31)
% E number of days in the month (0 ...... 31)
% M month, number (01 ...... 12)
% C month, number (1 ...... 12)
% B abbreviated month name (Jan ...... Dec)
% J days in a year (001 ...... 366)
% H hour (00 ...... 23)
% K hour (0 ...... 23)
% H hour (01 ...... 12)
% I hour (01 ...... 12)
% L hour (1 ...... 12)
% I minute, number (00 ...... 59)
% R time, 12 hours (HH: mm: ss [AP] m)
% T time, 24 hours (HH: mm: SS)
% S seconds (00 ...... 59)
% S seconds (00 ...... 59)
% P am or PM
% W days in a week (0 = Sunday ...... 6 = Saturday)
% U Week (0 ...... 52). Sunday is the first day of the week.
% U Week (0 ...... 52) Monday is the first day of the week.
% A text "% ".

Example:

SELECT FROM_UNIXTIME(1234567890, '%Y-%m-%d %H:%i:%S')

 

 

Select *, from_unixtime (created, '% Y-% m-% D') as riqi from 'rc _ ms_users'