rounding timestamps

From: "Claudio Lapidus" <clapidus(at)hotmail(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: rounding timestamps
Date: 2003-11-24 03:15:54
Message-ID: BAY7-DAV10Yxt0Gfwb300002210@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

(Sorry about reposting, but I'm still not arriving to any good solution for
this one)

I need to output a timestamp attribute formatted to fixed-width, no spaces
nor separators, something like

test=> select to_char(timestamp '2003-10-24 15:30:59.999',
'YYYYMMDDHH24MISS');
to_char
----------------
20031024153059
(1 row)

But my problem is that to_char truncates the fractional seconds, and I need
to round the value to the nearest integer second. In the above, I would need
the output rounded to 15:31:00, which is just a millisecond away, for
example. But I couldn't find a function to round a timestamp. Are there any
workaround?

thanks
cl.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2003-11-24 03:27:41 Re: rounding timestamps
Previous Message Craig O'Shannessy 2003-11-24 03:07:49 Re: Export CSV from psql