Page 1 of 1

select time difference in mysql query

Posted: Fri Mar 12, 2004 7:25 am
by yaron
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.