David,
My system (3.23.40-nt and MySQL-Front 1.18b as client) produces (what I think is) the
desired result using
both/either the NULL or NOW() alternatives - NOW (without function parentheses) is not
recognised.
However the INSERT statement below does not work without the addition of the VALU
My response below is incorrect, with regard to the NULL behavior. MySQL
will insert the current time and date for a TIMESTAMP only for the first
column *if* you omit the columns from the INSERT statement. If you set
the column to NULL explicitly, MySQL should set any TIMESTAMP to the current
dat
At 23:41 + 1/4/02, David Ayliffe wrote:
>I have created a test table with:
>
>CREATE TABLE TimeTest (
>Time1 TIMESTAMP(4),
>Time2 TIMESTAMP(8),
>Time3 TIMESTAMP(10),
>Time4 TIMESTAMP(12),
>Time5 TIMESTAMP(14));
>
>This works fine! No problemo
>
>Now ALL I am trying to do is insert the current
difference!
> Any other ideas?
>
> -Original Message-
> From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]]
> Sent: 05 January 2002 00:12
> To: David Ayliffe
> Cc: 'MySQL'
> Subject: Re: OK - Simple Timestamps problem getting the better of me!
>
> Did y
NO, not originally but I have now and it seems to make no difference!
Any other ideas?
-Original Message-
From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2002 00:12
To: David Ayliffe
Cc: 'MySQL'
Subject: Re: OK - Simple Timestamps problem getting the be
Did you define the columns as NOT NULL?
Bogdan
David Ayliffe wrote:
> I have created a test table with:
>
> CREATE TABLE TimeTest (
> Time1 TIMESTAMP(4),
> Time2 TIMESTAMP(8),
> Time3 TIMESTAMP(10),
> Time4 TIMESTAMP(12),
> Time5 TIMESTAMP(14));
>
> This works fine! No problemo
>
> Now ALL I a
I have created a test table with:
CREATE TABLE TimeTest (
Time1 TIMESTAMP(4),
Time2 TIMESTAMP(8),
Time3 TIMESTAMP(10),
Time4 TIMESTAMP(12),
Time5 TIMESTAMP(14));
This works fine! No problemo
Now ALL I am trying to do is insert the current time and date into each
field in the table!! That's al
