From_unixtime formatting MySQL timestamp function

function: from_unixtime function: mysql with int ( One) The time stored is "YYYY-Mm-DD "format to display. Syntax: From_unixtime (Unix_timestamp,format) returns a String representing the Unix time tag, formatted according to the format string. FORMAT can contain the same modifiers as the entries listed in the Date_format () function. Formats the date value according to the format string. The following modifiers can be used in the format string:%M-month name (January ... December)%W-week name (Sunday ... Saturday)%D The date of the month with English prefixes (1st, 2nd, 3rd, etc.). )%Y years, numbers,4bit%Y years, numbers,2bit%a abbreviated weekday name (Sun ... Sat)%Number of days in the D-month, number (xx...... to)%Number of days in the E-month, number (0...... to)%M-month, number ( on...... A)%C Month, number (1...... A)%b Abbreviated month name (Jan ...Dec)%J Number of Days in a year (001......366)%H Hours (xx...... at)%K Hours (0...... at)%H Hours ( on...... A)%I-Hour ( on...... A)%L Hours (1...... A)%I minute, number (xx...... -)%R time, AHours (hh:mm:ss[AP]M)%T time, -hours (HH:MM:SS)%s seconds (xx...... -)%s seconds (xx...... -)%P AM or PM%W one days in the week (0=Sunday ...6=Saturday)%U Week (0...... the), here Sunday is the first day of the week%U Week (0...... the), here Monday is the first day of the week%%A text "%". Example:SELECTFrom_unixtime (1234567890,'%y-%m-%d%h:%i:%s')SELECT *, From_unixtime (created,'%y-%m-%d') asRiqi from' Rc_ms_users '

From_unixtime formatting MySQL timestamp function