[thelist] Re: Access: Recording time

Casey Crookston casey at thecrookstons.com
Tue Jul 15 01:09:26 CDT 2003


Okay then.  I googled "ISO Date Format" and quickly found that it means:

YYYY-MM-DD

So I entered "2003-07-01", and Access seems to have converted it to
"6/17/1905"

I'm close to going to bed and hoping all this will stop in the morning.



----- Original Message -----
From: "Casey Crookston" <casey at thecrookstons.com>
To: <thelist at lists.evolt.org>
Sent: Tuesday, July 15, 2003 1:05 AM
Subject: Access: Recording time


>
> > > <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