mysql >=4.1 required (Bugs)

by done, Friday, March 09, 2007, 11:31 (6230 days ago) @ Alex
edited by done, Friday, March 09, 2007, 12:42

I think, it would be best to use unix-timestamps to garantuee
compatibility.

Hm..., the manual says: "TIMESTAMP columns are displayed in the same
format as DATETIME columns. In other words, the display width is fixed at
19 characters, and the format is YYYY-MM-DD HH:MM:SS."

the manual also says: "From MySQL 4.1.0 on, TIMESTAMP display format differs from that of earlier MySQL releases". (http://dev.mysql.com/doc/refman/4.1/en/timestamp-4-1.html)
the format used to be YYYYMMDDHHMMSS in releases below 4.1.
however, that wasn't the problem.
I had to set CURRENT_TIMESTAMP in qotes.

locked
8745 views

Complete thread:

 RSS Feed of thread