interval times - select # of minutes

From: <>
Date: Mon, 17 Mar 2008 02:09:00 -0700 (PDT)
Message-ID: <>

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

Original text of this message