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
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
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 better of me
?
-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 you define the columns as NOT NULL?
Bogdan
David Ayliffe wrote:
I have
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 time and
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