Re: interval times - select # of minutes
Date: Mon, 17 Mar 2008 12:14:35 +0100
"www.douglassdavis.com" <douglass_davis_at_earthlink.net> 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