Been scouring Google, looking for an ORACLE equivalent to SQL Server "DatePart". I found one thing, and it's not working:
WHERE DatePart(tbl.DateField,DP_YEAR) = 2012
I keep getting a "DATEPART: invalid identifier" message. This is Oracle 10g.
Does anyone know the proper way to compare the year portion of a date to a value like "2012"?