I recently received a notice from my web space provider according to installation of new version of mySQL (current 4.0.22, new 4.1.17). There is an incompatibility regarding TIMESTAMP:
-------------------------------------
Incompatible change: TIMESTAMP is now returned as a string in
'YYYY-MM-DD HH:MM:SS' format (from 4.0.12 the --new option can be
used to make a 4.0 server behave as 4.1 in this respect). See section
11.3.1.2 TIMESTAMP Properties as of MySQL 4.1. If you want to have the
value returned as a number (as MySQL 4.0 does) you should add +0 to
TIMESTAMP columns when you retrieve them:
SELECT ts_col + 0 FROM tbl_name;
-------------------------------------
Should any changes be made inside the sorcecode of phpwcms?
Thanks a lot!
TIMESTAMP-incompatibility in mySQL 4.1
-
Earl of Mar
- Posts: 20
- Joined: Sun 26. Sep 2004, 09:41
- Location: Hamburg
-
Earl of Mar
- Posts: 20
- Joined: Sun 26. Sep 2004, 09:41
- Location: Hamburg