Style Arguments for the CONVERT Function
|
Style
|
Associated
standard
|
Input/Output
( 3 ) format
|
date
|
time(n)
|
datetime2(n)
|
datetimeoffset(n)
|
|
0 or 100 (1,
2)
|
Default
|
mon dd
yyyy hh:miAM (or PM)
|
Jan 1
2001
|
12:20PM
|
Jan 1
2001 12:20PM
|
Jan 1
2001 12:20PM -08:00
|
|
101
|
U.S.
|
mm/dd/yyyy
|
1/1/2001
|
-
|
1/1/2001
|
1/1/2001
|
|
102
|
ANSI
|
yy.mm.dd
|
2001.01.01
|
-
|
2001.01.01
|
2001.01.01
|
|
103
|
British/French
|
dd/mm/yy
|
1/1/2001
|
-
|
1/1/2001
|
1/1/2001
|
|
104
|
German
|
dd.mm.yy
|
01.01.2001
|
-
|
01.01.2001
|
01.01.2001
|
|
105
|
Italian
|
dd-mm-yy
|
1/1/2001
|
-
|
1/1/2001
|
1/1/2001
|
|
106 (1)
|
-
|
dd mon
yy
|
1-Jan-01
|
-
|
1-Jan-01
|
1-Jan-01
|
|
107 (1)
|
-
|
Mon dd,
yy
|
1-Jan-01
|
-
|
1-Jan-01
|
1-Jan-01
|
|
108
|
-
|
hh:mi:ss
|
-
|
12:20:20
|
12:20:20
|
12:20:20
|
|
9 or 109 (1,
2)
|
Default
+ milliseconds
|
mon dd
yyyy hh:mi:ss:mmmAM (or PM)
|
Jan 1
2001
|
12:20:20.1234567AM
|
Jan 1
2001 12:20:20.1234567PM
|
Jan 1
2001 12:20:20:1230000PM -08:00
|
|
110
|
United States
|
mm-dd-yy
|
1/1/2001
|
-
|
1/1/2001
|
1/1/2001
|
|
111
|
JAPAN
|
yy/mm/dd
|
1/1/2001
|
-
|
1/1/2001
|
1/1/2001
|
|
112
|
ISO
|
yymmdd
|
20010101
|
-
|
20010101
|
20010101
|
|
13 or 113 (1,
2)
|
Europe
default + milliseconds
|
dd mon
yyyy hh:mi:ss:mmm(24h)
|
1-Jan-01
|
20:20.1
|
20:20.1
|
01 Jan
2001 12:20:20:1230000 -08:00
|
|
114
|
-
|
hh:mi:ss:mmm(24h)
|
-
|
20:20.1
|
20:20.1
|
12:20:20:1230000
-08:00
|
|
20 or 120 (2)
|
ODBC
canonical
|
yyyy-mm-dd
hh:mi:ss(24h)
|
1/1/2001
|
12:20:20
|
1/1/2001
12:20
|
2001-01-01
12:20:20 -08:00
|
|
21 or 121 (2)
|
ODBC
canonical (with milliseconds)
|
yyyy-mm-dd
hh:mi:ss.mmm(24h)
|
1/1/2001
|
20:20.1
|
20:20.1
|
2001-01-01
12:20:20.1230000 -08:00
|
|
126 (4)
|
ISO8601
|
yyyy-mm-ddThh:mi:ss.mmm
(no spaces)
|
1/1/2001
|
20:20.1
|
2001-01-01T
12:20:20.1234567
|
2001-01-01T
12:20:20.1234567
|
|
127(6, 7)
|
ISO8601
with time zone Z.
|
yyyy-mm-ddThh:mi:ss.mmmZ
|
1/1/2001
|
12:20:20.1234567Z
|
2001-01-01T
12:20:20.1234567Z
|
2001-01-01T20:20:20.1230000Z
|
|
|
||||||
|
(no
spaces)
|
||||||
|
130 (1, 2)
|
Hijri (5)
|
dd mon
yyyy hh:mi:ss:mmmAM
|
1-Jan-01
|
12:20:20.1230000PM
|
01 Jan
2001 12:20:20.1230000PM
|
1 Jan
2001 12:20:20:1230000PM -08:00
|
|
131 (2)
|
Hijri (5)
|
dd/mm/yy
hh:mi:ss:mmmAM
|
1/1/2001
|
12:20:20.1230000PM
|
01/01/2001
12:20:20.1230000PM
|
01/01/2001
12:20:20.1230000PM -08:00
|
No comments:
Post a Comment