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.
- References:
- Re: how to trunc date column to half an hour
- From: Jason Heinrich
- RE: how to trunc date column to half an hour
- From: Herring Dave - dherri
Other related posts:
- » how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- » RE: how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- » RE: how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- » RE: how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- » Re: how to trunc date column to half an hour
- Re: how to trunc date column to half an hour
- From: Jason Heinrich
- RE: how to trunc date column to half an hour
- From: Herring Dave - dherri