Formatting DateTime in SQL Server 2005/2008

SELECT convert(varchar, getdate(), 100) -- Dec 30 2009 8:16PM

SELECT convert(varchar, getdate(), 101) -- 12/30/2009

SELECT convert(varchar, getdate(), 102) -- 2009.12.30

SELECT convert(varchar, getdate(), 103) -- 30/12/2009

SELECT convert(varchar, getdate(), 104) -- 30.12.2009

SELECT convert(varchar, getdate(), 105) -- 30-12-2009

SELECT convert(varchar, getdate(), 106) -- 30 Dec 2009

SELECT convert(varchar, getdate(), 107) -- Dec 30, 2009

SELECT convert(varchar, getdate(), 108) -- 20:18:00

SELECT convert(varchar, getdate(), 109) -- Dec 30 2009 8:18:07:620PM

SELECT convert(varchar, getdate(), 110) -- 12-30-2009

SELECT convert(varchar, getdate(), 111) -- 2009/12/30

SELECT convert(varchar, getdate(), 112) -- 20091230

SELECT convert(varchar, getdate(), 113) -- 30 Dec 2009 20:18:40:607

SELECT convert(varchar, getdate(), 114) -- 20:18:48:027

SELECT convert(varchar, getdate(), 120) -- 2009-12-30 20:18:59

SELECT convert(varchar, getdate(), 121) -- 2009-12-30 20:19:46.230

SELECT convert(varchar, getdate(), 126) -- 2009-12-30T20:20:01.243

SELECT convert(varchar, getdate(), 0) -- Dec 30 2009 8:20PM

SELECT convert(varchar, getdate(), 1) -- 12/30/09

SELECT convert(varchar, getdate(), 2) -- 09.12.30

SELECT convert(varchar, getdate(), 3) -- 30/12/09

SELECT convert(varchar, getdate(), 4) -- 30.12.09

SELECT convert(varchar, getdate(), 5) -- 30-12-09

SELECT convert(varchar, getdate(), 6) -- 30 Dec 09

SELECT convert(varchar, getdate(), 7) -- Dec 30, 09

SELECT convert(varchar, getdate(), 8) -- 20:21:28

SELECT convert(varchar, getdate(), 9) -- Dec 30 2009 8:21:37:240PM

SELECT convert(varchar, getdate(), 10) -- 12-30-09

SELECT convert(varchar, getdate(), 11) -- 09/12/30

SELECT convert(varchar, getdate(), 12) -- 091230

SELECT convert(varchar, getdate(), 13) -- 30 Dec 2009 20:24:36:657

SELECT convert(varchar, getdate(), 14) -- 20:24:44:330

SELECT convert(varchar, getdate(), 20) -- 2009-12-30 20:24:52

SELECT convert(varchar, getdate(), 21) -- 2009-12-30 20:25:01.623

SELECT convert(varchar, getdate(), 22) -- 12/30/09 8:25:08 PM

SELECT convert(varchar, getdate(), 23) -- 2009-12-30

SELECT convert(varchar, getdate(), 24) -- 20:25:22

SELECT convert(varchar, getdate(), 25) -- 2009-12-30 20:25:29.763

Posted by Derek Trauger on Wednesday, December 30, 2009

Tags: SQL

Knowledge Base