 <p>I think you are probably looking for <a href="http://technet.microsoft.com/en-us/library/bb677335%28v=sql.105%29.aspx" rel="nofollow">datetime2(6)</a> in SQL Server 2008.</p> <blockquote> <p>Defines a date that is combined with a time of day that is based on 24-hour clock. datetime2 can be considered as an extension of the existing datetime type that has a larger date range, a larger default fractional precision, <strong>and optional user-specified precision.</strong></p> </blockquote>