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
T-SQL Programming
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