Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rounding Time
you can use the ROUND-function in PL/SQL e. g.
select to_char( round(sysdate, 'HH24'), 'DD.MM.YYYY HH24:MI:SS') from dual;
for the nearest hour of the current time.
louster_at_my-deja.com wrote:
> I'm trying to round a time to the nearest hour on a 24 hr clock. I'm
> currently trying something like:
>
> TO_CHAR(L.LOGIN_DATE,'fmHH24')+(TRUNC(TO_CHAR
> (L.LOGIN_DATE,'fmMI')/30)) || ':00' as "Rounded"
>
> But the problem with this is 11:31pm rounds up to 24:00 but 1:29am
> rounds to 0:00. I can't have both 24:00 and 0:00. I'd like 11:31pm to
> round to 0:00. Any ideas?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 13 2000 - 00:00:00 CDT