Format Date in Microsoft SQL Server
| |
Select Convert(Varchar(20), GetDate(), 100)
|
Apr 17 2011 7:32PM |
| |
Select Convert(Varchar(10), GetDate(), 101)
|
04/17/2011 |
| |
Select Convert(Varchar(10), GetDate(), 102)
|
2011.04.17 |
| |
Select Convert(Varchar(10), GetDate(), 103)
|
17/04/2011 |
| |
Select Convert(Varchar(10), GetDate(), 104)
|
17.04.2011 |
| |
Select Convert(Varchar(20), GetDate(), 105)
|
17-04-2011 |
| |
Select Convert(Varchar(10), GetDate(), 106)
|
17 Apr 2011 |
| |
Select Convert(Varchar(10), GetDate(), 107)
|
Apr 17, 2011 |
| |
Select Convert(Varchar(10), GetDate(), 108)
|
19:46:26 |
| |
Select Convert(Varchar(25), GetDate(), 109)
|
Apr 17 2011 7:47:03:933PM |
| |
Select Convert(Varchar(20), GetDate(), 110)
|
04-17-2011
|
| |
Select Convert(Varchar(10), GetDate(), 111)
|
2011/04/17 |
| |
Select Convert(Varchar(10), GetDate(), 112)
|
20110417 |
| |
Select Convert(Varchar(25), GetDate(), 113)
|
17 Apr 2011 19:50:20:700 |
| |
Select Convert(Varchar(10), GetDate(), 114)
|
19:50:35:867 |
| |
Select Convert(Varchar(20), GetDate(), 120)
|
2011-04-17 19:50:54
|
| |
Select Convert(Varchar(25), GetDate(), 121)
|
2011-04-17 19:51:10.950 |
| |
Select Convert(Varchar(25), GetDate(), 126)
|
2011-04-17T19:52:30.360 |