rtroiana wrote:
Hi All,
I have recently noticed in the MySQL 5.0 documentation in section 11.3.1.
The DATETIME, DATE, and TIMESTAMP Types, it's mentioned that
"TIMESTAMP values cannot be earlier than 1970 or later than 2037. This means
that a date such as '1968-01-01', while legal as a DATETIME or DATE value,
is not valid as a TIMESTAMP value and is converted to 0."
Is that a correct range for TimeStamp? It's not big enough to be used in a
real life application.
Why not?
It is not 2037 yet.
Timestamp is designed to record when records are updated, not for
storing arbitrary dates and times.
I plan to use DATETIME instead of TIMESTAMP. I used to use
"CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP" as default value for my
TimeStamp column. Is there a way to assign default value to a DateTime
column, since I couldn't find that in the documentation?
Thanks,
Reema
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
