⌂ Date & Time
Functions
- ADDDATE()
- ADDTIME()
- CURDATE()
- CURRENT_DATE()
- CURRENT_TIME()
- CURRENT_TIMESTAMP()
- CURTIME()
- DATE()
- DATEDIFF()
- DATE_ADD()
- DATE_FORMAT()
- DATE_SUB()
- DAY()
- DAYOFMONTH()
- DAYOFYEAR()
- HOUR()
- MICROSECOND()
- MINUTE()
- MONTH()
- NOW()
- SECOND()
- TIME()
- TIMEDIFF()
- UNIX_TIMESTAMP()
- WEEK()
- WEEKDAY()
- YEAR()

DATE _FORMAT()

Formats a date, time or timestamp value according to the format string.

Prototype

string DATE_FORMAT(mixed $timestamp, string $format)

Parameters

timestamp - A date ("YYYY-MM-DD"), time ("HH:MM:SS") or timestamp ("YYYY-MM-DD HH:MM:SS").
format - A string of text with special codes that start with the % character followed by a format specifier character, which will be replaced with the corresponding value based on the timestamp.

Format Codes

Code	Description
%a	Abbreviated weekday name (Sun to Sat)
%b	Abbreviated month name (Jan to Dec)
%c	Numeric month name (0 to 12)
%D	Day of the month as a numeric value, followed by suffix (1st, 2nd, 3rd, ...)
%d	Day of the month as a numeric value (01 to 31)
%e	Day of the month as a numeric value (0 to 31)
%f	Microseconds (000000 to 999999)
%H	Hour (00 to 23)
%h	Hour (00 to 12)
%I	Hour (00 to 12)
%i	Minutes (00 to 59)
%j	Day of the year (001 to 366)
%k	Hour (0 to 23)
%l	Hour (1 to 12)
%M	Month name in full (January to December)
%m	Month name as a numeric value (00 to 12)
%p	AM or PM
%r	Time in 12 hour AM or PM format (hh:mm:ss AM/PM)
%S	Seconds (00 to 59)
%s	Seconds (00 to 59)
%T	Time in 24 hour format (hh:mm:ss)
%U	Week where Sunday is the first day of the week (00 to 53)
%u	Week where Monday is the first day of the week (00 to 53)
%V	Week where Sunday is the first day of the week (01 to 53). Used with %X
%v	Week where Monday is the first day of the week (01 to 53). Used with %X
%W	Weekday name in full (Sunday to Saturday)
%w	Day of the week where Sunday=0 and Saturday=6
%X	Year for the week where Sunday is the first day of the week. Used with %V
%x	Year for the week where Monday is the first day of the week. Used with %V
%Y	Year as a numeric, 4-digit value
%y	Year as a numeric, 2-digit value

Return

The format string with the format codes replaced by the corresponding value based on the timestamp. NULL is returned if there is an error, such as an invalid timestamp.

Example

SELECT OID, DATE_FORMAT(META(LastModified),'%b %D, %Y') AS DateModified FROM User

cTemplate #FORMAT(), MySQL DATE_FORMAT()

webCOMAND