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

• Next in forum: Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
• Prev in forum: Re: Help needed with DATETIME Arithmetic
• Thread view: Re: formatting for a birth date field??

[Reply to this message]