RE: how to trunc date column to half an hour

Not sure exactly what you're after but do either of these help?
 
SQL> select to_char(sysdate, 'HH') from dual;
TO
--
02
 
 
SQL> select to_char(sysdate, 'HH24') from dual;
TO
--
14
SQL>

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Derya Oktay
Sent: Tue 3/6/2007 11:16 AM
To: oracle-l
Subject: how to trunc date column to half an hour


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: