Friday, February 22, 2008

Sql Date Time formats.

Fromhttp://lists.evolt.org/archive/Week-of-Mon-20020617/115646.html























without
century (yy)
with
century
(yyyy)
standardoutputformat
-0 or 100 (*)defaultmon dd yyyy hh:miAM (or PM)
1101USAmm/dd/yy
2102ANSIyy.mm.dd
3103British/Frenchdd/mm/yy
4104Germandd.mm.yy
5105Italiandd-mm-yy
6106-dd mon yy
7107-mon dd, yy
8108-hh:mm:ss
-9 or 109 (*)default
milliseconds
mon dd yyyy hh:mi:ss:mmmAM (or PM)
10110USAmm-dd-yy
11111Japanyy/mm/dd
12112ISOyymmdd
-13 or 113 (*)Europe default
milliseconds
dd mon yyyy hh:mm:ss:mmm(24h)
14114-hh:mi:ss:mmm(24h)
20120-yyyy-mm-dd hh:mi:ss(24h)
21121-yyyy-mm-dd hh:mi:ss.mmm(24h)
-126-yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
-130-dd mon yyyy hh:mi:ss:mmmAM
-131-dd/mm/yy hh:mi:ss:mmmAM

(*) the default values (style 0 or 100, 9 or 109, and
13 or 113) always return the century (yyyy)

Labels:

0 Comments:

Post a Comment

<< Home