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
: *Himerus* [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 05, 2001 12:26 AM
To: [EMAIL PROTECTED]
Subject: help with timestamp...
Can anyone give me a good link on how to put in a timestamp on a form
that inserts directly into a sql database??? I keep trying it, but it's
only coming th
> At 11:25 PM 12/4/01 -0700, *Himerus* wrote:
> >Can anyone give me a good link on how to put in a timestamp on a form
> >that inserts directly into a sql database??? I keep trying it, but it's
> >only coming thru as 00 , so on.
I enter my timestamp as a unix timestamp in an INT field
Hi,
Depends on what type of timestamp you are looking at. But
in general, you use the mysql built in function:
now() and if you want to convert that into unix_timestamp,
unix_timestamp(now()) will do the trick.
mysql> select now();
+-+
| now() |
+--
Can anyone give me a good link on how to put in a timestamp on a form
that inserts directly into a sql database??? I keep trying it, but it's
only coming thru as 00 , so on.
Thanks.
Newbie Jake.
-
Before posting,
10 matches
Mail list logo