|
|
Posted by tlyczko on 09/19/06 22:06
Erland Sommarskog wrote:
> 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)
Hello Erland,
Thank you for taking time to reply...you'll get a lot of stars from
me!! :) :)
Now I know what to read about to begin understanding your statement
above, I'll also add that constraint and check to the field itself (and
other fields too).
Thank you, Tom
Navigation:
[Reply to this message]
|