ginal Message-
> From: Proemial
> Sent: Friday, September 04, 2009 3:39 PM
> To: mysql@lists.mysql.com
> Subject: Fwd: Help with Timestamp invalid value error
>
> Currently set to:
> NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
(0)7812 451238
> Email j...@butterflysystems.co.uk
>
> Certified MySQL 5 Database Administrator (CMDBA)
> Certified MySQL 5 Developer
> Cognos BI Developer
>
> ---
> Sent from HP IPAQ mobile device.
>
>
>
> -Original Message-----
> From: Proemial
s.mysql.com
Subject: Fwd: Help with Timestamp invalid value error
Currently set to:
NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
On Fri, Sep 4, 2009 at 10:24 AM, John
Daisley wrote:
> What is your sql_mode set to?
>
> I tried inserting that value int
>
>
>
> -Original Message-
> From: Proemial
> Sent: Friday, September 04, 2009 2:27 PM
> To: mysql@lists.mysql.com
> Subject: Help with Timestamp invalid value error
>
> I run a process which loads a series of timestamped data into a table.
> I use the TI
Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: Proemial
Sent: Friday, September 04, 2009 2:27 PM
To: mysql@lists.mysql.com
Subject: Help with Timestamp invalid value error
I run a process which loads a series of timestamped data into a table.
I
I run a process which loads a series of timestamped data into a table.
I use the TIMESTAMP column.
I have a single value with a timestamp of '2008-03-9 2:56:34.737'
which fails on insert with 'incorrect datetime'. Days before, and
after work. Hours later in the day work. I thought it might be
