Re: interval times - select # of minutes

From: Shakespeare <>
Date: Mon, 17 Mar 2008 12:14:35 +0100
Message-ID: <47de5295$0$14351$>

"" <> schreef in bericht
> 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?

Take a look at the post in this group march 5 2008: How to design schema for time information. You may find some inspiration there, look at the INTERVAL data type.

Shakespeare Received on Mon Mar 17 2008 - 06:14:35 CDT

Original text of this message