Should be a date. Leaving it at midnight is perfectly acceptable. Dates
only take 7 bytes and give you flexibility to treat them as dates.
Jim
"Ian McCall" <ian_at_eruvia.org> wrote in message
news:JWsRa.13224$nP.7506_at_newsfep4-winn.server.ntli.net...
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in
> message news:rpoRa.79756$ye4.58653_at_sccrnsc01...
> > Additionally,Why are you converting a date to a string and then
comparing
> it
> > to a field that in all likelyhood is a date?
>
> The field is an existing table, and is a varchar(8). It forms part of a
> primary key, which is why dates were avoided (don't want to accidently add
> timing resolution beyond that of one day).
>
>
> Cheers,
> Ian
>
>
Received on Thu Jul 17 2003 - 03:36:59 CDT
