I’m writing this in response to Adam Machanic’s – T-SQL Tuesday - #001: Date/Time Tricks.
Here’s the a very useful script I still use all the time. I created it when I was working on a reporting project – it simply displays all the different date formats in SQL server.
--If you are looking to display dates, this script is a must!
---it prints out all the date formats and you can choose
SET NOCOUNT ON
Declare @TList table (
[TheDate] varchar(50) NOT NULL,
[Style] [int] NOT NULL)
--This will take care of 0 - 14
declare @counter int
set @counter = 0
while @counter < 15
begin
Insert @TList Select convert(varchar(50), Getdate(), @counter), @counter
set @counter = @counter + 1
end
--This will take care of 100 - 114
declare @counter2 int
set @counter2 = 100
while @counter2 < 115
begin
Insert @TList Select convert(varchar(50), Getdate(), @counter2), @counter2
set @counter2 = @counter2 + 1
end
Select * from @TList
