-
Notifications
You must be signed in to change notification settings - Fork 0
/
DateConvert.sql
26 lines (21 loc) · 963 Bytes
/
DateConvert.sql
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
-- MONTH FIRST
SELECT CONVERT(VARCHAR(12),GETDATE(), 101) -- 06/29/2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 110) -- 06-29-2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 100) -- JUN 29 2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 107) -- JUN 29, 2009
-- YEAR FIRST
SELECT CONVERT(VARCHAR(12),GETDATE(), 102) -- 2009.06.29
SELECT CONVERT(VARCHAR(12),GETDATE(), 111) -- 2009/06/29
SELECT CONVERT(VARCHAR(12),GETDATE(), 112) -- 20090629
-- DAY FIRST
SELECT CONVERT(VARCHAR(12),GETDATE(), 103) -- 29/06/2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 105) -- 29-06-2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 104) -- 29.06.2009
SELECT CONVERT(VARCHAR(12),GETDATE(), 106) -- 29 JUN 2009
-- TIME ONLY
SELECT CONVERT(VARCHAR(12),GETDATE(), 108) -- 07:26:16
SELECT CONVERT(VARCHAR(12),GETDATE(), 114) -- 07:27:11:203
-- DATE ONLY NO TIME (SQL 2008)
SELECT CAST(GETDATE() AS DATE); -- 08/12/2011
SELECT CAST(GETDATE() AS TIME); -- 11:05:04.0487