Re: how to trunc date column to half an hour

From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Tue, 06 Mar 2007 20:46:03 +0100
Message-ID: <45EDC4FB.8010007@roughsea.com>

SQL> select sysdate,

  2         trunc(sysdate) +
  3         trunc(to_number(to_char(sysdate, 'SSSSS'))/1800)/48

  4 from dual
  5 /

SYSDATE TRUNC(SYSDATE)+T

---------------- ----------------

06/03/2007 20:45 06/03/2007 20:30

SQL> HTH Stéphane Faroult

Derya Oktay 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.
>
>

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

Received on Tue Mar 06 2007 - 13:46:03 CST