Hi,
I have a dblink that I use to connect to a SQL SERVER database and I need to extract parts of a TImestamp field stored in a table in SQL SERVER and after stored in a table in my ORACLE SERVER
But when I try to extract any part of the date I receive some errors like this:
select * from "XYZ"@SQLDBLINK1 where EXTRACT(YEAR FROM "TimeStamp") = '2013'
ORA-02070: The Database XYZ dont support EXTRACT in this context
select * from "XYZ"@SQLDBLINK1 where DATEPART(yyyy,"TimeStamp") = '2013'
ORA-00904: "DATEPART": Identifier not valid
Any advice
Thanks in advance