Re: bug in 3.23.22-beta

2001-01-19 Thread Vivek Khera
> "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

Re: bug in 3.23.22-beta

2001-01-19 Thread Basil Hussain
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

Re: bug in 3.23.22-beta

2001-01-19 Thread Rolf Hopkins
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. - Original Message - From: "Marc Swanson" <[EMAIL PROTECTED]> To: "mysql list" <[EMAIL P