This is how I got my DateTime to have Military time.
SELECT CONVERT(VARCHAR, GetDate(), 101) + ' ' +
CONVERT(VARCHAR, GetDate(), 108)
Thursday, February 20, 2014
Date Time formats in SQL Query
I am currently converting SSRS reports from Oracle to SQL. I needed the DateTime in the 24 hour format. So here's what I found about the different formats. After putting the following statements in my query, my results are as follows.
Select
convert(varchar, getdate(), 100),
convert(varchar, getdate(), 101),
convert(varchar, getdate(), 102),
convert(varchar, getdate(), 103),
convert(varchar, getdate(), 104),
convert(varchar, getdate(), 105),
convert(varchar, getdate(), 106),
convert(varchar, getdate(), 107),
convert(varchar, getdate(), 108),
convert(varchar, getdate(), 109),
convert(varchar, getdate(), 110),
convert(varchar, getdate(), 111),
convert(varchar, getdate(), 112),
convert(varchar, getdate(), 113),
convert(varchar, getdate(), 114),
convert(varchar, getdate(), 120),
convert(varchar, getdate(), 121),
convert(varchar, getdate(), 126),
convert(varchar, getdate(), 127),
convert(varchar, getdate(), 130),
convert(varchar, getdate(), 131),
From Your Table Name
Here are the results.

Select
convert(varchar, getdate(), 100),
convert(varchar, getdate(), 101),
convert(varchar, getdate(), 102),
convert(varchar, getdate(), 103),
convert(varchar, getdate(), 104),
convert(varchar, getdate(), 105),
convert(varchar, getdate(), 106),
convert(varchar, getdate(), 107),
convert(varchar, getdate(), 108),
convert(varchar, getdate(), 109),
convert(varchar, getdate(), 110),
convert(varchar, getdate(), 111),
convert(varchar, getdate(), 112),
convert(varchar, getdate(), 113),
convert(varchar, getdate(), 114),
convert(varchar, getdate(), 120),
convert(varchar, getdate(), 121),
convert(varchar, getdate(), 126),
convert(varchar, getdate(), 127),
convert(varchar, getdate(), 130),
convert(varchar, getdate(), 131),
From Your Table Name
Here are the results.
Subscribe to:
Posts (Atom)