InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 14:10:22 GMT20http://www.sqlservercentral.com/Forums/Topic848125-1710-1.aspxHi, This is great. We use the following constraint and sanitation before assignment on date only columns in SQL 2005:[code="sql"]check (dateAdd(dd, datediff(dd, 0, datetimeColumn), 0) = datetimeColumn)[/code]I believe at least some of your wishes MS has implemented in SQL 2008. See here under embedded links: [url=http://msdn.microsoft.com/en-us/library/ms186724.aspx]http://msdn.microsoft.com[/url] and here [url=http://www.sql-server-performance.com/articles/dev/datetime_2008_p1.aspx]http://www.sql-server-performance.com[/url].[quote]The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types introduced. They are DATE, TIME, DATETIMEOFFSET and DATETIME2. IN addition to these newly introduced data types, there are new DATETIME functions all well.[/quote]Wed, 20 Jan 2010 09:06:34 GMTrajmundrhttp://www.sqlservercentral.com/Forums/Topic848125-1710-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/DateTime/69124/">datetime precision</A>[/B]Fri, 15 Jan 2010 01:40:45 GMTBill Talada