Re: How to give where condition on date in SQL - Page 2 - Qlik Community

Report Inappropriate Content · ‎2013-03-16

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...

Report Inappropriate Content · ‎2013-03-16

again error:

ErrorSource: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

kaushiknsolanki · ‎2013-03-16

Dear Rashmi,

What is the version of your Oracle?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Report Inappropriate Content · ‎2013-03-16

Version 11

Report Inappropriate Content · ‎2013-03-16

Version 11

kaushiknsolanki · ‎2013-03-16

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!