2 (of many) solutions here:
Create the column as a datetime instead and set it with NOW() when you first
insert the data.
In your update query, set the hr_con column to the current value.
(If you set the value explicitly it will not be updated with the automatic
timestamp value.)
read this for
leave alone for
subsequent updates.
Best regards,
Mikhail.
- Original Message -
From: "Leandro Saggin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 07, 2004 2:12 PM
Subject: Timestamp Problems
Hello,
I am having
Hello,
I am having problems with columns timestamp, what it happens is the following:
I created the following table using timestamp and inserted data in this table:
create table con(cod integer not null primary key auto_increment, cod_access integer,
hr_con timestamp(14), hr_descon timestamp(1
