EXTRACT versur TO_CHAR

Is there any performance differences between using:

EXTRACT(MONTH FROM variable) and TO_CHAR(variable,'MM')

or do they both perform just as efficiently as the other?

I have some PL/SQL code where it is using the EXTRACT to compare date portions of one field against date portions of another field.

Thanks. Received on Wed Feb 28 2007 - 20:51:33 CST