How to convert mysql date to string

How to convert mysql date to a string?

Mysql date to string method

Mysql convert date to string

select date_format(time, '%Y-%m-%d %H:%i:%s') from  info   # 2019-08-22 21:03:21

MySQL DATE_FORMAT() function

MySQL Date function

Definition and usage

DATE_FORMAT() function is used to display in different formats Date/time data.

Syntax

DATE_FORMAT(date,format)

The date parameter is a legal date. format specifies the date/time output format.

The formats that can be used are:

Format and description

%a abbreviated week name

%b abbreviated month name

%c Month, value

%D Day of the month with English prefix

%d Day of the month, value (00-31)

%e Day of the month, value (0-31)

%f microseconds

%H hours (00-23)

%h hours (01-12)

%I hour (01-12)

%i minute, value (00-59)

%j day of year (001-366)

%k hour (0-23)

%l hour (1-12)

%M month name

%m month, value (00-12)

%p AM or PM

%r Time, 12-hour (hh:mm:ss AM or PM)

%S seconds (00-59)

%s Seconds (00-59)

%T Time, 24-hour (hh:mm:ss)

%U Week (00-53) Sunday is the first day of the week Day

%u Week(00-53) Monday is the first day of the week

%V Week(01-53) Sunday is the first day of the week, used with %X

%v Week (01-53) Monday is the first day of the week, and %x uses

%W week name

%w day of the week (0= Sunday, 6=Saturday)

%X years where Sunday is the first day of the week, 4 digits, used with %V

%x years where Monday is the first day of the week Day 1, 4 digits, with %v using

%Y year, 4 digits

%y year, 2 digits

Instance

The following script uses the DATE_FORMAT() function to display different formats. We use NOW() to get the current date/time:

DATE_FORMAT(NOW(),'%b %d %Y %h:%i %p')
DATE_FORMAT(NOW(),'%m-%d-%Y')
DATE_FORMAT(NOW(),'%d %b %y')
DATE_FORMAT(NOW(),'%d %b %Y %T:%f')

The result is similar:

Dec 29 2008 11:45 PM
12-29-2008
29 Dec 08
29 Dec 2008 16:25:46.635

(free learning video tutorial recommendation: mysql video tutorial)

The above is the detailed content of How to convert mysql date to string. For more information, please follow other related articles on the PHP Chinese website!