Specifications

D Day of the week in 3-character abbreviated text format. Range is from
“Mon” to “Sun”.
F Month of the year in full text format. Range is from “January” to
“December”.
g Hour of the day in 12-hour format without leading zeroes. Range is from
“1” to “12”.
G Hour of the day in 24-hour format without leading zeroes. Range is from
“0” to “23”.
h Hour of the day in 12-hour format with leading zeroes. Range is from
“01” to “12”.
H Hour of the day in 24-hour format with leading zeroes. Range is from
“00” to “23”.
i Minutes past the hour with leading zeroes. Range is from “00” to “59”.
I Daylight savings time, represented as a Boolean value. This will return
“1” if the date is in daylight savings and “0” if it is not.
j Day of the month as a number without leading zeroes. Range is from “1”
to “31”.
l Day of the week in full text format. Range is from “Monday” to
“Sunday”.
L Leap year, represented as a Boolean value. This will return “1” if the date
is in a leap year and “0” if it is not.
m Month of the year as a 2-digit number with leading zeroes. Range is from
“01” to “12”.
M Month of the year in 3-character abbreviated text format. Range is from
“Jan” to “Dec”.
n Month of the year as a number without leading zeroes. Range is from “1”
to “12”.
s Seconds past the minute with leading zeroes. Range is from “00” to “59”.
S Ordinal suffix for dates in 2-character format. This can be “st”, “nd”,
“rd”, or “th”, depending on the number it is after.
t Total number of days in the date’s month. Range is from “28” to “31”.
T Timezone setting of the server in 3-character format, for example, “EST”.
U Total number of seconds from 1 January 1970 to this time; a.k.a., a
UNIX time stamp for this date.
Managing the Date and Time
C
HAPTER 18
18
MANAGING THE
DATE AND TIME
393
TABLE 18.1 Continued
Code Description
23 7842 CH18 3/6/01 3:43 PM Page 393