On 22 May 2007 10:08:24 -0700, jws <[EMAIL PROTECTED]> 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
