SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

TO_CHAR or TRUNC? Which one is more efficient?

UllhasAug 8 2011 — edited Aug 8 2011

Hi,

Which one is more efficient? TO_CHAR or TRUNC? (Primarily for of DATE columns)
Like for following queries. If I use the functions in group by clause which one could give better performance.

select to_char(sysdate, 'DD/MM/YYYY') from dual;

select trunc(sysdate) from dual;

Regards,
Ullhas

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2011

Added on Aug 8 2011

8 comments

15,663 views