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.















No comments:

Post a Comment