Fetching records greater then datetime does not work in c# windows service application

Question

Hi All I have the following queries (both are for same purpose) which fetches records greater the the datetime column. SELECT PROSPECT.BUSINESS_UNITPROSPECT.LAST_CHANGED FROM PROSPECT WHERE (TO_CHAR(LAST_CHANGED 'YYYY-MM-DD HH24:MI:SS') > (SELECT TO_CHAR(LAST_UPDATED 'YYYY-MM-DD HH24:MI:SS') FROM LAST_UPDATE)) SELECT PROSPECT.BUSINESS_UNITPROSPECT.LAST_CHANGED FROM PROSPECT WHERE LAST_CHANGED > (SELECT LAST_UPDATED FROM LAST_UPDATE)) This query works fine in query window and also in the windows console application. But the same query does not work from c# Application. Could any one has any idea why this behaves differently in c# windows service application. Regards Venkatesh G

Deepak Verma · Answer

Hi Venkatesh In both of queries you are comparing a column with multiple values (returned by select query). It is not allowed. Second thing You don't need to convert DATETIME to any other type for comparison. Check for you query in 'Query Window' it must be different.

venkatesh g · Answer

Thank you Deepak. You are right the subquery is was return 2 records. And even conversion is not required. i used it since in case if required. Thanks again Regards venkatesh g