UPDATE table SET active = 0 WHERE updated <
DATE_SUB(NOW(),INTERVAL 48 HOUR)
see the manual for more info
http://www.mysql.com/doc/en/Date_and_time_functions.html#IDX1322
olinux
--- Scott Haneda <[EMAIL PROTECTED]> wrote:
> I have a timestamp(14) column, I need to
> expire/decay certain records
on 9/27/03 7:55 PM, PeterWR at [EMAIL PROTECTED] wrote:
> 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 i
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 us
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 =
--
---
