Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> how to trunc date column to half an hour

how to trunc date column to half an hour

From: Derya Oktay <deryaoktay_at_gmail.com>
Date: Tue, 6 Mar 2007 20:16:28 +0200
Message-ID: <35ca1e480703061016w69df3145jd904941d5f3a9ffa@mail.gmail.com>


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 - 12:16:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US