On 9/24/07, Mark Morgan Lloyd <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to