Database polling query not returning result from ESB Flow

Hello All,

I am new to ESB Mule. I am trying to get number of records count from database table using poll oracle database. I provided the query as mentioned below.

SELECT COUNT(1) FROM <TABLE NAME> WHERE TO_DATE(TO_CHAR(<COLUMN NAME>), 'DD-MON-YY') = TO_DATE(SYSDATE, 'DD-MON-YY')

I am getting result If I run the above query in SQL+ directly. But not getting any result when I incorporate the same in Database Poll Query part.

Can anyone suggest for this issue.