Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am loading the data from a VIEW which is created in SQL but WHERE condition is not working.
SQL
SELECT * FROM NEWC."VIW_MONTHLY" WHERE CALLDATE>='01/01/2013 00:00:00';
condition is not working im getting all 2010 data also. Kindly help me...
again error:
ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string
Dear Rashmi,
What is the version of your Oracle?
Regards,
Kaushik Solanki
Version 11
Version 11
Try this.
Select * from NWEC."VIW_MONTHLY" where CALLDATE >= to_date('01-JAN-2013 12:00:00','DD-MON-RRRR HH24:MI:SS')
Regards,
Kaushik Solanki