[thelist] Access: Recording time
Casey Crookston
casey at thecrookstons.com
Tue Jul 15 01:05:48 CDT 2003
> > <tip type="sql">
> > don't play guessing games with your dates -- always specify your date
> > literals in ISO format, because every database understands that format,
> and
> > you will never have to depend on regional settings, locales, american
> versus
> > british interpretations, et cetera, ad nauseam
> > </tip>
Funny... I am just now running into an issue with this in access. I have a
column defined as date/time, and when I try to assign the value "7/1/2003"
it ends up being "12:05:01 AM". i can manualy enter dates just fine, but
when adding or updating via ASP it assigns them as times.
??
Casey
More information about the thelist
mailing list