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 being updated every time the record is modified, then you can use
an INT column type.
However, I agree with the above - you should use a DATE or DATETIME field
instead. You can always easily output one of these column types as a
timestamp value with the UNIX_TIMESTAMP() function.
Regards,
------------------------------------------------
Basil Hussain ([EMAIL PROTECTED])
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
