Home >Backend Development >PHP Tutorial >Mysql date and function do not ask for help_PHP tutorial
Mysql date and function do not ask for help_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:00:17850browse
DATE_FORMAT(date,format)
Format 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 day of the month with English prefix (1st, 2nd, 3rd, etc.)
%Y year, number, 4 digits
%y year, number, 2 digits
%a abbreviated day of the week name (Sun......Sat)
%d Number of days in the month, number (00……31)
%e Number of days in the month, number (0……31)
%m Month, number (01……12)
%c Month, Number (1...12)
%b Abbreviated month name (Jan...Dec)
%j Number of days in a year (001...366)
%H Hour (00...23)
%k hours (0…23)
%h hours (01…12)
%I hours (01…12)
%l hours (1…12)
%i minutes, 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 The number of days in a week (0=Sunday…6=Saturday)
%U Week (0……52), here Sunday is the first day of the week
%u Week (0……52), here Monday is the first day of the week
%% A text "%".
All other characters are copied to the result without interpretation.
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'
mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
-> '22:23:00'
mysql> select DATE_FORMAT(' 1997-10-04 22:23:00',
'%D %y %a %d %m %b %j');
-> '4th 97 Sat 04 10 Oct 277'
mysql> select DATE_FORMAT('1997-10-04 22:23:00',
'%H %k %I %r %T %S %w');
-> '22 22 10 10:23:00 PM 22:23:00 00 6'
In MySQL3.23, % is required before the format modifier character. In earlier versions of MySQL, % was optional.
TIME_FORMAT(time,format)
This is used like the DATE_FORMAT() function above, but the format string can only contain those format modifiers that handle hours, minutes, and seconds.
Other modifiers produce a NULL value or 0.
CURDATE()
CURRENT_DATE
Returns today's date value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context.
mysql> select CURDATE();
-> '1997-12-15'
mysql> select CURDATE() 0;