Hi experts, I need create a function, similar to ROUND
Example, if I do:
select TO_CHAR (ROUND (TO_DATE ('11-SEP-1994 4:17 PM', 'DD-MON-YY HH:MI AM'), 'HH'),'DD-MON-YY HH:MI AM') from dual;
11-SEP-94 04:00 PM
I need to obtain:
11-SEP-94 04:15 PM
The function should return the nearest point every 5 minutes.
Could you indicate me what I need for obtain this?
I need to apply this function in rows over a tables, and then convert a date column, with the new values calculated.
Thankyou in advanced!