Why does this query returns no output

I have one record in DB (attached)

but why does this query does not return output

/* Formatted on 25/04/2011 3:43:22 PM (QP5 v5.136.908.31019) */
SELECT S.*
  FROM SCHEME S
 WHERE TO_DATE (SYSDATE, 'DD/MM/YYYY:HH:MI SSPM') >= S.EFFECTIVEDATEFROM
       AND TO_DATE (SYSDATE, 'DD/MM/YYYY:HH:MI SSPM') <= S.EFFECTIVEDATETO
       
       
data.txt
GRChandrashekarAsked:
Who is Participating?
 
Pratima PharandeCommented:
SELECT S.*
  FROM SCHEME S
 WHERE TO_DATE (SYSDATE, 'DD/MM/YYYY:HH:MI SSPM') >= TO_DATE (S.EFFECTIVEDATEFROM ,'DD/MM/YYYY:HH:MI SSPM')
       AND TO_DATE (SYSDATE, 'DD/MM/YYYY:HH:MI SSPM') <= TO_DATE (S.EFFECTIVEDATETO ,'DD/MM/YYYY:HH:MI SSPM')
0
 
sdstuberCommented:
>>>  TO_DATE (SYSDATE, 'DD/MM/YYYY:HH:MI SSPM')

this is wrong


SYSDATE is already a date


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.