Many times I want a particular date format but can’t remember which style it is. Below is a list of the styles and examples of how it will display. I don’t know if there are any additional Styles, if you know of any, comment and I can add them.
Usage:
CONVERT(VARCHAR, GETDATE(), 1) AS [Date]
Style | Date |
1 | 02/24/17 |
2 | 17.02.24 |
3 | 24/02/17 |
4 | 24.02.17 |
5 | 24-02-17 |
6 | 24 Feb 17 |
7 | Feb 24, 17 |
8 | 13:10:36 |
9 | Feb 24 2017 1:10:36:037PM |
10 | 02-24-17 |
11 | 17/02/24 |
12 | 170224 |
13 | 24 Feb 2017 13:10:36:037 |
14 | 13:10:36:037 |
20 | 2017-02-24 13:10:36 |
21 | 2017-02-24 13:10:36.037 |
22 | 02/24/17 1:10:36 PM |
23 | 2017-02-24 |
24 | 13:10:36 |
25 | 2017-02-24 13:10:36.037 |
100 | Feb 24 2017 1:10PM |
101 | 02/24/2017 |
102 | 2017.02.24 |
103 | 24/02/2017 |
104 | 24.02.2017 |
105 | 24-02-2017 |
106 | 24 Feb 2017 |
107 | Feb 24, 2017 |
108 | 13:10:36 |
109 | Feb 24 2017 1:10:36:037PM |
110 | 02-24-2017 |
111 | 2017/02/24 |
112 | 20170224 |
113 | 24 Feb 2017 13:10:36:037 |
114 | 13:10:36:037 |
120 | 2017-02-24 13:10:36 |
121 | 2017-02-24 13:10:36.037 |
126 | 2017-02-24T13:10:36.037 |
127 | 2017-02-24T13:10:36.037 |
131 | 28/05/1438 1:10:36:037PM |