how to trunc date column to half an hour

  • From: "Derya Oktay" <deryaoktay@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 6 Mar 2007 20:16:28 +0200

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.

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2007