Mega Code Archive
DATE_FORMAT Specifiers
<![CDATA[
Day
%a Day of the week in 3-letter abbreviation (Sun, Mon, etc.)
%D Day of the month abbreviated (1st, 2nd, etc.)
%d Day of the month in 2-digit numeric indicator (00-31)
%e Day of the month in numeric indicator (0-31)
%j Day of the year in 3-digit display (001-366)
%W Day of the week in full word (Sunday, Monday, etc.)
%w Day of the week in numeric form (1=Sunday, 2=Monday, etc.)
Month
%b Month of the year in 3-letter abbreviation (Jan, Feb, etc.)
%c Month of the year in numeric indicator (0-12)
%M Month of the year in full word (January, February, etc.)
%m Month of the year in 2-digit numeric indicator (00-12)
Year
%X Year in 4-digit numeric display, beginning with Sunday, for use with %V
%x Year in 4-digit numeric display, beginning with Sunday, for use with %v
%Y Year in 4-digit numeric display
%y Year in 2-digit numeric display
Week
%U Week of the year (00-53), beginning with Sunday
%u Week of the year (00-53), beginning with Monday
%V Week of the year (01-53), beginning with Sunday, for use with %X
%v Week of the year (01-53), beginning with Sunday, for use with %x
Hour
%H Hour in 2-digit, 24-hour time (00-23)
%h, %I Hour 2-digit, in 12-hour time (01-12)
%k Hour in 24-hour time (0-23)
%l Hour in 12-hour time (1-12)
Minute
%I Minute in 2-digit display (00-59)
%p Before noon or after noon (AM or PM)
Second
%f Microseconds in 6-digit display (000000-999999)
%S, %s Seconds in 2-digit numeric indicator (00-59)
Time
%r Time in 12-hour display, formatted HH:MM:SS, with AM or PM
%T Time in 24-hour display, formatted HH:MM:SS
Percent
%% Display of the percent symbol (%)
]]>