Not sure, but I think timestamp is a special field type used to identify a row uniquely (when exporting/importing data from other sources).
If you want to store a date/time value, then I'd use the date type, which also allows times. -----Original Message----- From: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 2:00 PM To: CF-Talk Subject: RE: CF and Time Why can a SQL server Db table only contain one field of type timestamp? I am not al that familiar with DBs yet. :-( Mike -----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:45 PM To: CF-Talk Subject: RE: CF and Time use timestamps. Timestamps are more versatile that varchars since you can do math calculations with them. Depending on your gui layout you may also be better off storing a start time and a duration rather than a start and end time. Definitely use Timestamps - you'll thank yourself later when you write the queries! +-----------------------------------------------+ 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: Tangorre, Michael T. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 12:35 PM To: CF-Talk Subject: CF and Time Hi everyone. I am looking for the best way and data type (SQL) to store a employees schedule. I have a form in which they enter a start time and an end time. Should I store these as Timestamps in SQL Server or use varchar... And what about AM and PM? Any ideas would be much appreciated. Mike Michael T. Tangorre======================== Resident Assistant - Brick Web Applications Developer A.U. Webteam Slave :-) AIM: CrazyFlash4======================== ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
