On 22 May 2007 10:08:24 -0700, jws <jsacksteder(at)gmail(dot)com> wrote:
>
> Is there a way to round an interval to the nearest minute or do I need
> to create a function for this?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
date_trunc('minute',interval)
see
http://www.postgresql.org/docs/8.2/interactive/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC
Peter Childs