if you are using SQL Server, use SMALLDATETIME
+-----------------------------------------------+
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: Shawn Grover [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 1:36 PM
To: CF-Talk
Subject: RE: CF and Time
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======================
______________________________________________________________________
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
