| 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: | Whole Thread | Raw Message | 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.
| 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 |