Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rounding minutes of DATE type in PL/SQL

Re: Rounding minutes of DATE type in PL/SQL

From: Peter & Mag <petermag_at_singnet.com.sg>
Date: Fri, 12 Feb 1999 22:47:35 +0800
Message-ID: <36C43F07.653F3383@singnet.com.sg> 





Basically take sysdate divide by 10 minutes, round it up, and then
multiple back by 10 min.   Correct?



ie: (round(sysdate*24*6)+1)/(24*6)?



Povodi Ohre a.s. wrote:


> 


> Dear Friends,


>               does anybody know how


> to round DATE type to 10th of minutes


> in PL/SQL?




-- 



Peter Teoh


Oracle Certified Professional
Received on Fri Feb 12 1999 - 08:47:35 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US