datetime precision

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by William Talada » datetime precision

datetime precision

Rate Topic

Display Mode

Topic Options

Author

Message

Bill Talada

Posted Friday, January 15, 2010 1:40 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:31 AM
Points: 65, Visits: 443

Comments posted to this topic are about the item datetime precision

Post #848125

rajmundr

Posted Wednesday, January 20, 2010 9:06 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, September 10, 2012 5:20 PM
Points: 13, Visits: 94

Hi, This is great. We use the following constraint and sanitation before assignment on date only columns in SQL 2005:

check (dateAdd(dd, datediff(dd, 0, datetimeColumn), 0) = datetimeColumn)

I believe at least some of your wishes MS has implemented in SQL 2008. See here under embedded links: http://msdn.microsoft.com and here http://www.sql-server-performance.com.

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.

Post #850572

« Prev Topic | Next Topic »

Permissions