Hi, I dont think so - the timestamp is a system-field, set by the system and can not be modifyed by users.
You probably have to make an additional datetime-field for You purpose - if You can do CONCAT(timestamp + NOW()) when it is INSERT, I dont know - try. best regards Peter ----- Original Message ----- From: "Scott Haneda" <[EMAIL PROTECTED]> To: "MySql" <[EMAIL PROTECTED]> Sent: Sunday, September 28, 2003 4:47 AM Subject: Selecting on timestamp(14) > I have a timestamp(14) column, I need to expire/decay certain records over > time, can I use NOW() and INTERVAL on a timestamp(14) column > > Looking to expire a record that is x hours old > > For example > Update table set active = '0' where updated = ???? > -- > ------------------------------------------------------------- > Scott Haneda Tel: 415.898.2602 > http://www.newgeo.com Fax: 313.557.5052 > [EMAIL PROTECTED] Novato, CA U.S.A. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
