ORA-00932 Inconsistent datatypes expected date got number
584906Jun 26 2007 — edited Jun 26 2007Hi everybody!
I have a sybase database which Im loading into a oracle system. I need to come up with a query to filter out the record with the last time stamp for the day. I have a field in my sybase database called asof_date of datetime datatype.
In the Informatica souce qualifier a SQL query to extract only record with the last timestamp.
Select * from table1 where asof_date = (select max(asof_date) from table1 where asof_date between 'fromdate' and 'todate')
I think in Sql, max(asof_date) gives me a number. I am not sure why cuz asof_date iof supposed to be a datetime datatype. Should i change that to date. will that help??? Could someone shed some light on this, please.
Your replies are much appreciated.