Posted by Erland Sommarskog on 09/19/06 21:06

tlyczko (tlyczko@gmail.com) writes:
> Hello, both ideas make sense, however, I now just need to learn how to
> update all the fields such that the TIME part for each datum is
> 00:00:00.etc., I don't need to worry about the time in a birth date
> field or anything similar...I'll do this as a separate post.

CONSTRAINT dateonly CHECK (convert(char(8), birthdate, 112) = birthdate)


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]