interval times - select # of minutes
Date: Mon, 17 Mar 2008 02:09:00 -0700 (PDT)
Is there an easy way to just select the number of minutes if you have an interval?
I have something like:
SELECT (due_date - CURRENT_TIMESTAMP) time_left FROM tablename
But this gives me an interval time.
It would be much easier if I could just get a number of minutes.
Is there an easy way to just get the number of minutes? Received on Mon Mar 17 2008 - 04:09:00 CDT