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