On Handling Dates in SQL

Posted on Simple Talk See other posts from Simple Talk
Published on Thu, 06 Mar 2014 00:00:00 GMT Indexed on 2014/05/26 21:56 UTC
Read the original article Hit count: 210

Filed under:

The calendar is inherently complex by the very nature of the astronomy that underlies the year, and the conflicting historical conventions. The handling of dates in TSQL is even more complex because, when SQL Server was Sybase, it was forced by the lack of prevailing standards in SQL to create its own ways of processing and formatting dates and times. Joe Celko looks forward to a future when it is possible to write standard SQL date-processing code with SQL Server.

© Simple Talk or respective owner

Related posts about T-SQL Programming