Mysql 日期时间 DATE_FORMAT(date,format)

来源：这里教程网时间：2026-02-28 06:54:12 作者：

Mysql 日期时间 DATE_FORMAT(date,format) ，需要的朋友可以参考下。

本文转自：http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html#function_date-format

DATE_FORMAT(<em class="replaceable"><code>date
,format
)

Formats the
date
value according to the format
string.

The following specifiers may be used in the
format
string. As of MySQL 3.23, the “” character is required before format specifier characters. In earlier versions of MySQL, “” was optional.

The
%v
,
%V
,
%x
, and
%X
format specifiers are available as of MySQL 3.23.8.
%f
is available as of MySQL 4.1.1.

Ranges for the month and day specifiers begin with zero due to the fact that MySQL permits the storing of incomplete dates such as
'2014-00-00'
(as of MySQL 3.23).

As of MySQL 4.1.21, the language used for day and month names and abbreviations is controlled by the value of the
lc_time_names
system variable (Section 9.8, “MySQL Server Locale Support”).

As of MySQL 4.1.23,
DATE_FORMAT()
returns a string with a character set and collation given by
character_set_connection
and
collation_connection
so that it can return month and weekday names containing non-ASCII characters. Before 4.1.23, the return value is a binary string.
SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');