October 20, 2014 at 8:56 am
Comments posted to this topic are about the item Datetime Formats
April 13, 2016 at 7:23 am
This is pretty cool, thanks.
Just ran it. I'll probably modify it to return blanks instead of NULL where applicable.
April 13, 2016 at 7:54 am
I'm not sure how this supposed to be used. Could someone give me an example?
April 13, 2016 at 8:00 am
It is a stored procedure. Once you compile it you can run it as below:
sp_datetime_formats (if no other SQL statement)
April 13, 2016 at 8:39 am
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
April 14, 2016 at 6:14 am
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply