> "MS" == Marc Swanson <[EMAIL PROTECTED]> writes:
MS> As you can see the date field has been updated to the current date/time even
MS> though the update query was only supposed to modify the text field. For
MS> claarity the date field started out with 2001-01-07 08:00:00 and ended up
MS> wi
Hi,
> That's no bug. That is what timestamp is, current date and current time no
> matter whether you insert or update. Read the manual more carefully. What
> I think you want is date column, not timestamp.
If you really do want to store an actual timestamp figure in your table
without it bei
"mysql list" <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 21:43
Subject: bug in 3.23.22-beta
> Hello list,
>
> I am wondering if this bug I found in 3.23.22-beta is a known bug that has
> been fixed in laater servers.
>
> How to replicate:
>
>
Hello list,
I am wondering if this bug I found in 3.23.22-beta is a known bug that has
been fixed in laater servers.
How to replicate:
create table test_bug (
text_field varchar(20) NOT NULL,
date_field timestamp(14)
);
insert into test_bug (text_field,date_field) values
('foo','2001010708
