interval times - select # of minutes

From: www.douglassdavis.com <douglass_davis_at_earthlink.net>
Date: Mon, 17 Mar 2008 02:09:00 -0700 (PDT)
Message-ID: <8f94080c-34ad-4ba0-876a-729851e4cb5e@x41g2000hsb.googlegroups.com>

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