[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