Maison > base de données > tutoriel mysql > Mysql 日期时间 DATE_FORMAT(date,format)

Mysql 日期时间 DATE_FORMAT(date,format)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
Libérer: 2016-06-07 18:03:06
original
1110 Les gens l'ont consulté

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.

    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');</CODE></STRONG>
        -> 'Sunday October 2009'
    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');</CODE></STRONG>
        -> '22:23:00'
    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('1900-10-04 22:23:00',</CODE></STRONG>
      -> <STRONG class=userinput><CODE>        '%D %y %a %d %m %b %j');</CODE></STRONG>
        -> '4th 00 Thu 04 10 Oct 277'
    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('1997-10-04 22:23:00',</CODE></STRONG>
      -> <STRONG class=userinput><CODE>        '%H %k %I %r %T %S %w');</CODE></STRONG>
        -> '22 22 10 10:23:00 PM 22:23:00 00 6'
    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('1999-01-01', '%X %V');</CODE></STRONG>
        -> '1998 52'
    mysql> <STRONG class=userinput><CODE>SELECT DATE_FORMAT('2006-06-00', '%d');</CODE></STRONG>
        -> '00'
    Copier après la connexion
  • Étiquettes associées:
    Déclaration de ce site Web
    Le contenu de cet article est volontairement contribué par les internautes et les droits d'auteur appartiennent à l'auteur original. Ce site n'assume aucune responsabilité légale correspondante. Si vous trouvez un contenu suspecté de plagiat ou de contrefaçon, veuillez contacter admin@php.cn
    Tutoriels populaires
    Plus>
    Derniers téléchargements
    Plus>
    effets Web
    Code source du site Web
    Matériel du site Web
    Modèle frontal