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 ______________________________________________________________________ Get Your Own 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=coldfusionb 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
