Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Tue Mar 06 2007 - 12:16:28 CST
![]() |
![]() |