Database Reference
In-Depth Information
Table 11-2. Date and time formatting codes
Code Description
Results
%a Abbreviated weekday name
(Sun…Sat)
%b Abbreviated month name
(Jan…Dec)
%c Month (numeric)
(1…12)
%d Day of the month (numeric)
(00…31)
%D Day of the month with English suffix
(1st, 2nd, 3rd, etc.)
%e Day of the month (numeric)
(0…31)
%f Microseconds (numeric)
(000000…999999)
%h Hour
(01…12)
%H Hour
(00…23)
%i Minutes (numeric)
(00…59)
%I Hour
(01…12)
%j Day of the year
(001…366)
%k Hour
(0…23)
%l Hour
(1…12)
%m Month (numeric)
(01…12)
%M Month name
(January…December)
%p AM or PM
AM or PM
%r Time, 12-hour
(hh:mm:ss [AP]M)
%s Seconds
(00…59)
%S Seconds
(00…59)
