Twitter

Follow SQLQuill on Twitter

Subscribe

MN Pass

Script to display all date formats

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

1 comment to Script to display all date formats

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>