Re: how to trunc date column to half an hour

  • From: "Derya Oktay" <deryaoktay@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 7 Mar 2007 09:47:24 +0200

Hi,
I need to use this function in group by clause, thus I will prefer using
trunc(sysdate) +   trunc(to_number(to_char(sysdate, 'SSSSS'))/1800)/48.

I really appreciate who replied, thank you.

Regards,
Derya.

Other related posts:

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