List:General Discussion« Previous MessageNext Message »
From:pedro mpa Date:February 12 2006 8:42pm
Subject:Timestamp error
View as plain text  
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.


Thread
Timestamp errorpedro mpa12 Feb
  • Re: Timestamp errorMichael Stassen13 Feb