Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to trunc date column to half an hour
Here's an article that covers that topic:
http://www.dbazine.com/oracle/or-articles/still2
On 3/6/07, Derya Oktay <deryaoktay_at_gmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 12 2007 - 18:12:48 CDT
![]() |
![]() |