I have been working further with date and time in mysql and discovered a strange problem. When I run the following query it puts the current datetime into the table fine:
insert into table values ('',SYSDATE())
However, when I try to put in a different date, for example, 10 minutes (600 seconds) from the current time with the following query it irecords only 6 minutes ahead, not ten. It appears that PHP treats minutes as 100 seconds long.
insert into table values ('',SYSDATE()+600)
I have searched the mysql site and others with no success. Does anyone know more about this?
Damien.