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_at_gmail.com> To: oracle-l <oracle-l_at_freelists.org> 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