| From: | Joshua Moore-Oliva <josh(at)chatgris(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Division of intervals. |
| Date: | 2003-03-19 00:32:48 |
| Message-ID: | 200303181932.48369.josh@chatgris.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Attempting rather unsuccessfully to convert something of the form
45 years 9 mons 5 days 20:28:18.886891
to a total number of months, I attempted
SELECT age(now(), timestamp '1957-06-13') / interval '1 month';
and got the error
ERROR: Unable to identify an operator '/' for types 'interval' and 'interval'
You will have to retype this query using an explicit cast
Does anyone know what interval format intervals are stored as? Is there a way
I can cast this expression to be able to find the number of months within
this interval?
Or is there a function I don't know about capable of doing this? (extracting
the total number of a specific interval from another interval)... e.g. total
number of months, total number of days...
Josh.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2003-03-19 00:47:58 | Re: Referential Integrity problem |
| Previous Message | Josh Berkus | 2003-03-19 00:21:43 | Limitations in PL/perl |