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