Datetime Formats

Question

Post reply

Datetime Formats

DougDeneau

SSC Enthusiast

Points: 128
More actions
October 20, 2014 at 8:56 am

#300254

Comments posted to this topic are about the item Datetime Formats

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

akljfhnlaflkj

SSC Guru

Points: 76202

April 13, 2016 at 7:23 am

#1871674

This is pretty cool, thanks.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

Just ran it. I'll probably modify it to return blanks instead of NULL where applicable.

nancy.lytle Default port Points: 1430 More actions · Answer 3

I'm not sure how this supposed to be used. Could someone give me an example?

DougDeneau SSC Enthusiast Points: 128 More actions · Answer 4

It is a stored procedure. Once you compile it you can run it as below:

EXEC sp_datetime_formats

or

sp_datetime_formats (if no other SQL statement)

nancy.lytle Default port Points: 1430 More actions · Answer 5

I might be dense but I was looking to see how I can use it if I run into a situation where I need to do a conversion. Is it just a list of conversion.

What if I have a query with the Where clause something like ColumnA(int) > getdate()-2

DougDeneau SSC Enthusiast Points: 128 More actions · Answer 6

I'm sorry, but the only thing this stored procedure does is to show the various formats available when converting a datetime field to a string value.