> Do you have any suggestions as how to solve this issue? Any help is much appreciated.
What version are you on? I would expect '2015-11-02 00:00:00.0' to be converted automatically to timestamp since it matches the expected format. Are there other circumstances where you are using alternative timestamp formats?
Thanks for the quick response.
We asked to double check the SQL that caused timestamp filter not pushing down to source, it actually was:
select * from WAAV where wins = 'H977401' and TimeStamp > '2015-11-02'
After correcting the format, timestamp filter was pushed down and query returned correct data.
Thank you for the help!