select * from table where mytimestamp (unix_timestamp - 20) ??
Gregory Machin schrieb:
Hi
What, is the easest way to select all the records created in the last 20 min
stay based on a column that has a timestamp record.
Many Thanks
--
Gregory Machin
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Hi, Gregory
Hmm.. I think you just should add something like 'create_time
DATE_SUB(NOW(), INTERVAL 20 MINUTE)' to a where clause of your query. Or
something similar..
You can find more at
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html.
Also consider creating of an
Hello Gregory,
What, is the easest way to select all the records created in the last 20
min
stay based on a column that has a timestamp record.
select * from mytable
where some_timestamp date_add(current_timestamp, interval -15 minute)
Martijn Tonies
Database Workbench - development tool
Hi
Thanks for you support hope you have a grate day ..
On 3/7/06, Martijn Tonies [EMAIL PROTECTED] wrote:
Hello Gregory,
What, is the easest way to select all the records created in the last 20
min
stay based on a column that has a timestamp record.
select * from mytable
where