How do you extract just the month from a date in netezza SQL?
The date shows as 05DEC2010.
I've tried extract(MONTH FROM CONTACT_DATE) although it doesn't work. Any ideas? I dont want just to extract a
Answer
It would seem that your contact_date field isn't actually a date field. You probably need to use:
extract(month from (contact_date::date))