Re: how to trunc date column to half an hour

You didn't give the algorithm but something like this may work:

select to_char(sysdate,'yyyy-mm-dd hh24:mi'), case when to_number(to_char(sysdate,'mi')) between 0 and 29 then to_char(sysdate,'yyyy-mm-dd hh24')||':00' else to_char(sysdate,'yyyy-mm-dd hh24')||':30' end from dual;

This "rounds back", if you want to round you may have to adjust it to increase the hour as well.

Regards,

Greg Rahn
http://structureddata.org


-------- Original Message --------
Subject: how to trunc date column to half an hour
From: "Derya Oktay" <deryaoktay@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: 3/6/2007 10:16 AM
Hi All,
Is there a way of displaying date columns, truncated to half an hours.

For example: select trunc(sysdate,'HH') from dual;

Regards,
Derya.


FYI. We are usig this sort of functions in group by expressions.

PS. Ghassan thank you for your answer regarding local/global index es in partitions.



--
http://www.freelists.org/webpage/oracle-l


Other related posts: