00:00 AM is midnight - the very beginning of a new day.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecomunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 2:59 PM
To: CF-Talk
Subject: Re: CF and Time AM and PM
Tangorre, Michael T. wrote:
> Hello again, :-)
>
> I have a form in which a user enters a time, but I need to be able to
> decipher between AM and PM.. Can they include this with their time?
> What is the best way to do this, I will be storing this in a datetime
field
> in a SQL DB.
The best way is to use the ISO 8601 format which says you have to use a
24 hour clock (ANSI standard as well). It also avoids a lot of
confusion
(How late exactly is 00:00AM? Midnight or noon? Answer: depends on
geographical location) and it makes sorting in the database a lot more
logical.
Jochem
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
