I'm not sure whether your question is about column types or the NOW() function.
TIMESTAMP fields are defined as being automatically updated every time the row is modified. If you want a field which simply holds a "timestamp" which does *not* get automatically updated, use a DATETIME or similar column type. If you want this column to have the "creation time" of the row, you've got to remember to set it to NOW() every time you do an INSERT. Unfortunately, I don't know any way to do the equivalent of setting the column default to NOW(). On 11/5/02 at 4:04 pm, Edilson Vasconcelos de Melo Junior <[EMAIL PROTECTED]> wrote: > Hi, > > I have a table with a timestamp field called dtins. When i insert a row to > the table, the value of this field is setted to NOW() just for the inserted > the record. My problem is when i update some record, its dtinst value is > change again, without a ask to :( How can i avoid this? Is there another > function that i can use to get the current datetime? > > Thank u very much, > > Edilson Vasconcelos de Melo Junior > www.jrsoftwares.com.br > [EMAIL PROTECTED] > Fone: (19) 3256-3577 > > > sql,query > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.361 / Virus Database: 199 - Release Date: 7/5/2002 > > > --------------------------------------------------------------------- > 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 > > --------------------------------------------------------------------- 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