Here's an article that covers that topic: http://www.dbazine.com/oracle/or-articles/still2 On 3/6/07, Derya Oktay <deryaoktay@xxxxxxxxx> wrote:
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.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist