difference between extract and date_part

Question

What is the exact difference between date_part() and extract functions in netezza?

Answer 1

In Netezza date_part and extract are equivalent functions. They provide different syntax for improved SQL compatibility, but are otherwise the same.

You can see this in the documentation here.

Answer 2

difference between date_part('week', ...) and extract(week from ...) not only but also from a performance point of view. I read extract is standard and date_part is not. Backwards compatibility maybe justifies the existence of date_part