On 9/24/07, Mark Morgan Lloyd <markMLl.pgsql-general@xxxxxxxxxxxxxxx> 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
