Tangorre, Michael T. wrote:
> Why can a SQL server Db table only contain one field of type timestamp?
> I am not al that familiar with DBs yet. :-(
If there ever was a time to get familiar with databases and datatypes it
is now. It is important that you recognize what you can do in a db and
what not. For instance, it is important to recognize the difference
between a time and an interval because you can do different math on each
of them.
Just as an example:
interval + interval = interval
datetime + interval = datetime
date + interval = datetime
(a date defaults to the time 00:00 on that day)
time + interval = error
(it is undefined what should happen if you cross midnight)
datetime + datetime = error
time + time = error
The definition of what can be done and what not is something like this
(or maybe they even left the time out). But every db vendor interprets
it differently.
In any case, reading the chapter on date/time fields, operators and
manipulation of your db manual is time well spend. Better spending a
morning reading a book as a week rewriting the application.
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
