Re: Hour difference? - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Hour difference?
Date
Msg-id 20030818190139.GB2816@wolff.to
Whole thread Raw
In response to Re: Hour difference?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
On Mon, Aug 18, 2003 at 11:19:35 -0700,
  Jonathan Bartlett <johnnyb@eskimo.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.

pgsql-general by date:

Previous
From: Dev
Date:
Subject: Default Value in Table Setup Help
Next
From: Bruno Wolff III
Date:
Subject: Re: Why lower's not accept an AS declaration ?