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