Dates

[Anon]

Hello,

Im trying to select a timestamp field that is older than a half hour from the current time in one SQL statement. My timestamp is like this:

20020116234031

Thanks.

[jburfield]

select TIMESTAMP_FIELD from TABLE where ((now() - TIMESTAMP_FIELD) / 60) > 30;

This will give you the raw timestamp field where it is more than 30 minutes old.

-- Jason

[Anon]

not too hard 🙂
select * from list where timestamp = $thistimestamp - 1800