select time difference in mysql query
Posted: Fri Mar 12, 2004 7:25 am
Hello all,
I need to get for a table the difference between the current time and a timestamp stored in the table.
Can I write something like this?
select dateinsert-now() from somewhere where dateinsert>now()-interval 15 minute
I need the diff in minutes.
I need to get for a table the difference between the current time and a timestamp stored in the table.
Can I write something like this?
select dateinsert-now() from somewhere where dateinsert>now()-interval 15 minute
I need the diff in minutes.