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