http://blogs.technet.com/patricg/archive/2008/09/01/date-and-time-with-sql-server.aspxPart 1: Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005 Understanding date/time data types in SQL Server can be difficult, especially when you add TIMESTAMP into the mix. In part one of this series on date/time, you'll learn thefr-FRCommunityServer 2.1 SP1 (Build: 61025.2)