Re: Best practice for specifying an interval - Mailing list pgsql-general

From Rodrigo De Le�
Subject Re: Best practice for specifying an interval
Date
Msg-id a55915760709240617m3762ed93t4fd3f1ddad5da35c@mail.gmail.com
Whole thread Raw
In response to Best practice for specifying an interval  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
List pgsql-general
On 9/24/07, Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk> wrote:
> In a similar vein, are fractional hours best specified as
>
>         select time '11:00' - interval '3 hour 45 minute';
>
> or as
>
>         select time '11:00' - interval '3.75 hour';
>
> or with the interval converted to an integer number of minutes?

Pg is pretty smart for almost any case.

See:
http://www.postgresql.org/docs/8.2/static/datetime-appendix.html

pgsql-general by date:

Previous
From: Niklas Johansson
Date:
Subject: Re: full join question...
Next
From: "Rodrigo De Le�"
Date:
Subject: Re: Transaction Steps!!