DATETIME search - SOLVED
Posted: Thu Jun 22, 2006 11:45 am
Hi group,
I have a database with a DATETIME field storing the timestamp when the record was created.
Records are added by a remote task from time to time.
I need a SELECT that can find all records created within the last 30 minutes. ie where "now() - timestamp <= 30 mins"
I can't figure out how so any help gratefully received.
Thanks,
David
I have a database with a DATETIME field storing the timestamp when the record was created.
Records are added by a remote task from time to time.
I need a SELECT that can find all records created within the last 30 minutes. ie where "now() - timestamp <= 30 mins"
I can't figure out how so any help gratefully received.
Thanks,
David