Convert Datetime format to String and the various styles
The following SQL code will convert a Datetime value to String. This particular query is converting the current date as an example. The number ’112′ is a style code that SQL server uses. This will return the date in YYYYMMDD format. There is also a table of the various Style Codes and the date format that they will return below that. Just insert the particular style code you want into the sql query to get the desired result.
select CONVERT(CHAR(8), getdate(), 112) as 'Date Format'
| Date Format | Style |
|---|---|
| Sep 16 2 | 0 |
| 09/16/09 | 1 |
| 09.09.16 | 2 |
| 16/09/09 | 3 |
| 16.09.09 | 4 |
| 16-09-09 | 5 |
| 16 Sep 0 | 6 |
| Sep 16, | 7 |
| 18:20:31 | 8 |
| Sep 16 2 | 9 |
| 09-16-09 | 10 |
| 09/09/16 | 11 |
| 090916 | 12 |
| 16 Sep 2 | 13 |
| 18:20:31 | 14 |
| 2009-09- | 20 |
| 2009-09- | 21 |
| 09/16/09 | 22 |
| 2009-09- | 23 |
| 18:20:31 | 24 |
| 2009-09- | 25 |
| Sep 16 2 | 100 |
| 09/16/20 | 101 |
| 2009.09. | 102 |
| 16/09/20 | 103 |
| 16.09.20 | 104 |
| 16-09-20 | 105 |
| 16 Sep 2 | 106 |
| Sep 16, | 107 |
| 18:20:31 | 108 |
| Sep 16 2 | 109 |
| 09-16-20 | 110 |
| 2009/09/ | 111 |
| 20090916 | 112 |
| 16 Sep 2 | 113 |
| 18:20:31 | 114 |
| 2009-09- | 120 |
| 2009-09- | 121 |
| 2009-09- | 126 |
| 2009-09- | 127 |
| 27 ????? | 130 |
| 27/09/14 | 131 |
Advertisement
