Rodrigo De Le? wrote:
Pg is pretty smart for almost any case.
Which still doesn't say anything about best practice. In the end I found the
relevant part of the SQL spec, correct forms are HOUR and MINUTE where the
associated numbers are integers.
--
Mark Morgan Lloyd
markMLl .AT. telemetry
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 numb
