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 -> Rounding a Date field in Oracle

Rounding a Date field in Oracle

From: JK <jim.katsos_at_oz.quest.com>
Date: Wed, 29 Jan 2003 16:00:03 +1100
Message-ID: <b17n4p$2fu$1@perki.connect.com.au> 





Does anyone know a way to round a date field  as shown below



10:15:45 = 10:15:50


10:15:53 = 10:16:00



basically round up to the nearest 10 second peroid to use in a group by
select.  The round function only allow you to round to the nearest minute.
Received on Tue Jan 28 2003 - 23:00:03 CST












Original text of this message













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