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
DATETIME search - SOLVED
Moderator: General Moderators
DATETIME search - SOLVED
Last edited by davidtee1 on Thu Jun 22, 2006 11:58 am, edited 1 time in total.
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- feyd
- Neighborhood Spidermoddy
- Posts: 31559
- Joined: Mon Mar 29, 2004 3:24 pm
- Location: Bothell, Washington, USA
DATEDIFF() and DATESUB() may be of interest.