Re: interval times - select # of minutes
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Mon, 17 Mar 2008 12:14:35 +0100
Message-ID: <47de5295$0$14351$e4fe514c@news.xs4all.nl>
Date: Mon, 17 Mar 2008 12:14:35 +0100
Message-ID: <47de5295$0$14351$e4fe514c@news.xs4all.nl>
"www.douglassdavis.com" <douglass_davis_at_earthlink.net> schreef in bericht
news:8f94080c-34ad-4ba0-876a-729851e4cb5e_at_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?
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