| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Jonathan Bartlett <johnnyb(at)eskimo(dot)com> |
| Cc: | Bjørn T Johansen <btj(at)havleik(dot)no>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Hour difference? |
| Date: | 2003-08-18 19:01:39 |
| Message-ID: | 20030818190139.GB2816@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Aug 18, 2003 at 11:19:35 -0700,
Jonathan Bartlett <johnnyb(at)eskimo(dot)com> wrote:
> Is there a way to get an interval in a standard format? It seems like it
> keeps changing it's ouput style based on the time length.
Extracting epoch from an interval will return the length in seconds.
(With months treated as having 30 days and years as having 12 months.
But that shouldn't matter for your application.) You can then make
calculations with that number to produce whatever output format you want.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-08-18 19:02:45 | Re: Simulating sequences |
| Previous Message | Bruno Wolff III | 2003-08-18 18:59:13 | Re: Why lower's not accept an AS declaration ? |