Copy codeThe Code is as follows:
Select * from table where DATE_FORMAT (FROM_UNIXTIME (createtime), '% Y-% m-% D') = '2017-01-02'
FROM_UNIXTIME use syntax
FROM_UNIXTIME (unix_timestamp, format)
FROM_UNIXTIME (unix_timestamp), FROM_UNIXTIME (unix_timestamp, format) is the time function in MySQL
, Unix_timestamp can be the field name or Unix time. format mainly formats the returned value.
If the format is provided, the format of the result is determined by the format string.
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 "%"