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