|
The following date/time field variables are used:
d
|
08/17/2000
|
D
|
Thursday, August 17, 2000
|
f
|
Thursday, August 17, 2000 16:32
|
F
|
Thursday, August 17, 2000 16:32:32
|
g
|
08/17/2000 16:32
|
G
|
08/17/2000 16:32:32
|
m
|
August 17
|
r
|
Thu, 17 Aug 2000 23:32:32 GMT
|
s
|
2000-08-17T16:32:32
|
|
|
t
|
16:32
|
T
|
16:32:32
|
u
|
2000-08-17 23:32:32Z
|
U
|
Thursday, August 17, 2000 23:32:32
|
y
|
August, 2000
|
|
|
d, dd, ddd, dddd
|
Current day of the month d, dd=numeric, ddd=abbreviation (ie, "Wed"), dddd=spelled out.
|
f, ff, fff, ffff, fffff
|
Fractions of a second, varying numbers of digits
|
h, hh Hours
|
12 hour format
|
H, HH Hours
|
24 hour format
|
m, mm:
|
Minutes
|
M, MM, MMM, MMMM
|
Month. MM = 2 digit, MMM = abbreviation (ie, "Jan"), MMMM=spelled out
|
s, ss
|
Seconds
|
t, tt
|
AM/PM indicator
|
y, yy, yyyy
|
Year
|
z, zz, zzz
|
Time zone offset from GMT. Time separator
|
/
|
Date separator
|
Any other character
|
Other characters
|
|
|
Examples:
|
|
dddd, MMMM dd yyyy
|
Thursday, August 17 2000
|
ddd, MMM d "'"yy
|
Thu, Aug 17 '00
|
dddd, MMMM dd
|
Thursday, August 17
|
M/yy
|
8/00
|
dd-MM-yy
|
17-08-00
|
More information:
Microsoft date time strings
|