Datetime Formats

  • Comments posted to this topic are about the item Datetime Formats

  • This is pretty cool, thanks.

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

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

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

    EXEC sp_datetime_formats


    sp_datetime_formats (if no other SQL statement)

  • 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

  • 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