Tag: query

Date Formats in SQL Server

SELECT CONVERT(VARCHAR,GETDATE(),103)

1) SELECT CONVERT(VARCHAR,GETDATE(),100)

Result —
May 13 2012 11:30AM

2) SELECT CONVERT(VARCHAR,GETDATE(),101)

Result —
05/13/2012

3) SELECT CONVERT(VARCHAR,GETDATE(),102)

Result —
2012.05.13

4) SELECT CONVERT(VARCHAR,GETDATE(),103)

Result —
13/05/2012

5) SELECT CONVERT(VARCHAR,GETDATE(),104)

Result —
13.05.2012

6) SELECT CONVERT(VARCHAR,GETDATE(),105)

Result —
13-05-2012

7) SELECT CONVERT(VARCHAR,GETDATE(),106)

Result —
13 May 2012

8) SELECT CONVERT(VARCHAR,GETDATE(),107)

Result —
May 13, 2012

9) SELECT CONVERT(VARCHAR,GETDATE(),108)

Result —
11:41:51

10) SELECT CONVERT(VARCHAR,GETDATE(),109)

Result —
May 13 2012 11:43:04:267AM

11) SELECT CONVERT(VARCHAR,GETDATE(),110)

Result —
05-13-2012

12) SELECT CONVERT(VARCHAR,GETDATE(),111)

Result —
2012/05/13

13) SELECT CONVERT(VARCHAR,GETDATE(),112)

Result —
20120513

14) SELECT CONVERT(VARCHAR,GETDATE(),113)

Result —
13 May 2012 11:50:02:510

15) SELECT CONVERT(VARCHAR,GETDATE(),114)

Result —
11:51:00:330

16) SELECT CONVERT(VARCHAR,GETutcDATE(),114)

Result —
06:21:55:597

And if you are looking for a SQL query to find the SQL version, then try this

select @@version

download