Re: timestamp
| From: | CPT John W. Holmes | Date: | Fri, 22 Aug 2003 19:25:03 +0000 |
| Subject: | Re: timestamp | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-160444@lists.php.net to get a copy of this message | ||
From: "John Taylor-Johnston" <taylorjo@collegesherbrooke.qc.ca>
> I'm creating a counter.
>
> I want a timestamp where I can calculate if a time stamp is older than one
hour, if so do X, if not do Y.
SELECT * FROM Table WHERE timestamp_column < NOW() - INTERVAL 60 MINUTE
will give you all rows that have a timestamp column that's over 60 minutes
old. Adapt to your needs.
---John Holmes..