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.
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"?
DBMS are far from my strong point especially oracle. But I'm not familiar with the DATEPART function. The error indicates that oracle isn't either (maybe a pl/sql specific?). I always use EXTRACT when I need to pull something out of Oracle by year:
Looks like it'll do it.
EXTRACT(YEAR from tbl.DateField) = 2012
Is that true for Backups and replicating the database are bigger and slower..
Plz anyone suggest me..
crewson, your question has nothing to do with this thread please start a separate thread.