Home Forums SQL Server 2008 T-SQL (SS2K8) Time intervals RE: Time intervals
Steve Cullen
SSCertifiable
Points: 5598
More actions
February 9, 2010 at 9:34 am
#1116216
We find it handy to keep a static calendar table around with dates and attributes such as IsHolliday and DayOfWeek, Month, Quarter, FiscalYear etc.
Ours starts at 1/1/1900 and goes to 12/31/2099.