Tuesday, January 23, 2007

SQL codes for date conversion

SQL codes for format date
























































































Style ID



Style Type


0 or 100
mon dd yyyy hh:miAM (or PM)
101mm/dd/yy
102yy.mm.dd
103dd/mm/yy
104dd.mm.yy
105dd-mm-yy
106dd mon yy
107Mon dd, yy
108hh:mm:ss
9 or 109
mon dd yyyy hh:mi:ss:mmmAM (or PM)
110mm-dd-yy
111yy/mm/dd
112yymmdd
13 or 113
dd mon yyyy hh:mm:ss:mmm(24h)
114hh:mi:ss:mmm(24h)
20 or 120
yyyy-mm-dd hh:mi:ss(24h)
21 or 121
yyyy-mm-dd hh:mi:ss.mmm(24h)
126yyyy-mm-dd Thh:mm:ss.mmm(no spaces)
130dd mon yyyy hh:mi:ss:mmmAM
131dd/mm/yy hh:mi:ss:mmmAM

1 comment:

Sukhjit said...

this is good but i need a code for format mm/dd/yy hh:mm:ss[am/pm].
Can u help me to tell the code for this format.