Greetings!
I am building a website using MySQL 5.0.18 and PHP 5.1.2.
When I try to insert in a table a timestamp value from php's mktime() I get
the following error:
1292: Incorrect datetime value: '1139776424' for column 'access_date' at row
1
The sql for the table is:
CREATE TABLE `members_acs` (
`id` int(17) unsigned NOT NULL auto_increment,
`member_id ` int(13) unsigned default NULL,
`access_date` timestamp NOT NULL default '0000-00-00 00:00:00',
`ip` varchar(15) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
Are timestamps different from php to mysql?
When I first create a timestamp field it defaults to CURRENT_TIMESTAMP then
the following will default to 0000-00-00 00:00:00 . Is this the normal
behaviour? What am I doing wrong?
Thanks in advance.
Pedr.
