Repository navigation
Expand file tree
/
Copy path10b_Date_Time_Date_Formats.sql
More file actions
122 lines (121 loc) · 2.54 KB
/
Copy path10b_Date_Time_Date_Formats.sql
File metadata and controls
122 lines (121 loc) · 2.54 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
/* ==============================================================================
SQL Date & Time | Date Format Specifiers
---------------------------------------------------------------------------------
All date and time format specifiers that can be used with the FORMAT() function.
This is the file opened in the video.
=================================================================================
*/
SELECT
'D' AS FormatType,
FORMAT(GETDATE(), 'D') AS FormattedValue,
'Full date pattern' AS Description
UNION ALL
SELECT
'd',
FORMAT(GETDATE(), 'd'),
'Short date pattern'
UNION ALL
SELECT
'dd',
FORMAT(GETDATE(), 'dd'),
'Day of month with leading zero'
UNION ALL
SELECT
'ddd',
FORMAT(GETDATE(), 'ddd'),
'Abbreviated name of day'
UNION ALL
SELECT
'dddd',
FORMAT(GETDATE(), 'dddd'),
'Full name of day'
UNION ALL
SELECT
'M',
FORMAT(GETDATE(), 'M'),
'Month without leading zero'
UNION ALL
SELECT
'MM',
FORMAT(GETDATE(), 'MM'),
'Month with leading zero'
UNION ALL
SELECT
'MMM',
FORMAT(GETDATE(), 'MMM'),
'Abbreviated name of month'
UNION ALL
SELECT
'MMMM',
FORMAT(GETDATE(), 'MMMM'),
'Full name of month'
UNION ALL
SELECT
'yy',
FORMAT(GETDATE(), 'yy'),
'Two-digit year'
UNION ALL
SELECT
'yyyy',
FORMAT(GETDATE(), 'yyyy'),
'Four-digit year'
UNION ALL
SELECT
'hh',
FORMAT(GETDATE(), 'hh'),
'Hour in 12-hour clock with leading zero'
UNION ALL
SELECT
'HH',
FORMAT(GETDATE(), 'HH'),
'Hour in 24-hour clock with leading zero'
UNION ALL
SELECT
'm',
FORMAT(GETDATE(), 'm'),
'Minutes without leading zero'
UNION ALL
SELECT
'mm',
FORMAT(GETDATE(), 'mm'),
'Minutes with leading zero'
UNION ALL
SELECT
's',
FORMAT(GETDATE(), 's'),
'Seconds without leading zero'
UNION ALL
SELECT
'ss',
FORMAT(GETDATE(), 'ss'),
'Seconds with leading zero'
UNION ALL
SELECT
'f',
FORMAT(GETDATE(), 'f'),
'Tenths of a second'
UNION ALL
SELECT
'ff',
FORMAT(GETDATE(), 'ff'),
'Hundredths of a second'
UNION ALL
SELECT
'fff',
FORMAT(GETDATE(), 'fff'),
'Milliseconds'
UNION ALL
SELECT
'T',
FORMAT(GETDATE(), 'T'),
'Full AM/PM designator'
UNION ALL
SELECT
't',
FORMAT(GETDATE(), 't'),
'Single character AM/PM designator'
UNION ALL
SELECT
'tt',
FORMAT(GETDATE(), 'tt'),
'Two character AM/PM designator';