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>
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