Template:MYSQLDATETIMEFORMATS
Revision as of 11:42, 11 November 2013 by Arthur Lathrop (talk | contribs) (Created page with ':{| border="1" cellpadding="5" |'''Format''' |'''Description''' |- |%M %d, %Y||will return date in format of ''September 30, 2012'' |- |%a||will return the truncated day of the w…')
Revision as of 11:42, 11 November 2013 by Arthur Lathrop (talk | contribs) (Created page with ':{| border="1" cellpadding="5" |'''Format''' |'''Description''' |- |%M %d, %Y||will return date in format of ''September 30, 2012'' |- |%a||will return the truncated day of the w…')
Format Description %M %d, %Y will return date in format of September 30, 2012 %a will return the truncated day of the week, e.g. Sun. for Sunday %b will return the truncated name of the month, e.g. Sep for September %c will return the month number in short format, e.g. 9 for September %d will return the numeric day of month (01-31) %e will return the numeric day of month (1-31) %h will return hour (01-12) %i will return minutes (00-59) %j will return day of year (001-366) %k will return hour (0-23) %l will return hour (1-12) %m will return the month number, e.g. 09 for September %p will return AM/PM information, e.g. AM %r will return the full time in 12-hour format, e.g. 12:00:00 AM %s will return seconds (00-59) %u will return the week number (00-53) where Monday is the first day of the week %w day of the week (0=Sunday...6=Saturday) %y will return the truncated year, e.g. 12 for 2012 %D will return the month ordinal, e.g. 30th %H will return hour (00-23) %M will return the month name, e.g. September %T will return the full time in 24-hour format, e.g. 23:00:00 %U will return the week number (00-53) where Sunday is the first day of the week %W will return the day of the week, e.g. Sunday %Y will return the four-digit year, e.g. 2013