MySQL Date_format () function

Definition and usage

The Date_format () function is used to display date/time data in different formats.

Grammar

Date_format (Date,format)

The date parameter is a valid day. format Specifies the date/time in which the output is formatted.

Detailed reference: http://www.w3school.com.cn/sql/func_date_format.asp

Example

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 ')

Output Result:

Dec 11:45 pm12-29-200829 Dec 0829 Dec 2008 16:25:46.635

MySQL Date_format () function