Re: Incorrect timestamp value
Posted by: Glenn Puckett
Date: May 22, 2013 04:10PM

I am at an even bigger quandry now. I implemented log4jdbc to get the actual data being applied to MySQL. In the statement that fails the specific field that is failing contains:

last_labor_rpt_date='2013-05-22 17:55:05'

The entire update statement is:

update xyz.account_tbl set acct_type=1, industry_role_id=18, contr_type='N',
date_joined='2008-11-10', date_paid=NULL, description=NULL, fee_paid=0.00, labor_alt_descr='',
last_activity_date='2013-05-22', last_labor_rpt_date='2013-05-22 17:55:05', name='Test Account',
due_date='2013-01-31', status=1, website_url='' where id=71;

The table definition is:

use xyz;

CREATE TABLE `account_tbl` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`website_url` varchar(255) DEFAULT NULL,
`date_joined` date NOT NULL,
`last_activity_date` date NOT NULL,
`industry_role_id` int(11) unsigned NOT NULL DEFAULT '0',
`acct_type` tinyint(4) DEFAULT '-1',
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`description` text,
`last_labor_rpt_date` timestamp NULL DEFAULT NULL,
`labor_alt_descr` text,
`fee_paid` decimal(8,2) DEFAULT '0.00',
`date_paid` date DEFAULT NULL,
`due_date` date DEFAULT NULL,
`contr_type` char(1) DEFAULT NULL,
UNIQUE KEY `account_name_idx` (`name`),
KEY `FK_ACCT_INDROLE` (`industry_role_id`),
CONSTRAINT `FK_ACCT_INDROLE` FOREIGN KEY (`industry_role_id`) REFERENCES `admin_industry_role_tbl` (`id`) ON UPDATE NO ACTION

I don't understand why this statement is failing.

Options: ReplyQuote

Written By
Re: Incorrect timestamp value
May 22, 2013 04:10PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.