--- id: 1 title: 'T-SQL Tuesday #001: Date/Time Tricks' date: '2009-12-01T19:14:07+00:00' author: way0utwest layout: post permalink: '/001' categories: - Uncategorized tags: - '2009' - 'Date and time' --- Hosted by Adam Machanic. [Invite](http://sqlblog.com/blogs/adam_machanic/archive/2009/11/30/invitation-to-participate-in-t-sql-tuesday-001-date-time-tricks.aspx) and [roundup](http://sqlblog.com/blogs/adam_machanic/archive/2009/12/09/t-sql-tuesday-001-the-roundup.aspx) If you bothered to read the title of this post you’re aware that **the topic for this month is Date/Time Tricks**. Write a blog post that talks about dates and times–this can be based around T-SQL programming, data modeling, ETL, reporting, or whatever else you’re using dates and times for (and who isn’t?).