Eschewing Date Types in our Database
Posted by: Karl Seguin [MVP],
on 29 Oct 2009 |
View original | Bookmarked: 0 time(s)
About a month ago, I found myself transforming data for the reporting portion of our application. Like many reporting systems, ours works off of date ranges, with statistics grouped together by the day (and a few by the hour). An early prototype made heavy use of TSQL Date functions (like DateAdd and DatePart). However, I wasn't happy with this solution, my transformations were unnecessarily coupled to SQL Server. I mean, database date functions all do pretty primitive date arithmetic's,...