Convert
Sql Server Function
Refer to MSDN for the full listing
| With century (yyyy) |
Standard |
Input/Output |
| 101 |
U.S |
mm/dd/yyyy |
| 102 |
ANSI |
yy.mm.dd |
| 110 |
USA |
mm-dd-yy |
| 112 |
ISO |
yyyymmdd |
| 114 |
|
hh:mi:ss:mmm(24h) |
| Expression |
Results |
| select Convert(varchar,GETDATE(),101) |
04/01/2009 |
| select Convert(varchar,GETDATE(),101) |
2009.04.01 |
| select Convert(varchar,GETDATE(),101) |
04-01-2009 |
| select Convert(varchar,GETDATE(),101) |
20090401 |
| select Convert(varchar,GETDATE(),101) |
18:23:16:080 |
|