Re: Best practice for specifying an interval

["Rodrigo De Le�" <rdeleonp(at)gmail(dot)com>]

On 9/24/07, Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)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