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.
All trademarks and copyrights within the FreeLists archives are owned by
their respective owners.
Everything else ©2000-2012 Avenir Technologies, LLC.
FreeLists is a service of Avenir Technologies, LLC.