I get format code appears twice error in the following query
SELECT SCHEMEDETAIL.DISCOUNTAMOUNT,
SCHEMEDETAIL.DISCOUNTPERCENT,
SCHEME.SCHEME_ID
FROM SCHEME, SCHEMEDETAIL
WHERE (SCHEME.SCHEME_ID = SCHEMEDETAIL.SCHEME_ID)
AND (SCHEME.FLAG = 0)
AND (SCHEMEDETAIL.FLAG = 0)
AND SYSDATE BETWEEN TO_DATE (EFFECTIVEDATEFROM, 'DD/MM/YYYY HH:MM')
AND TO_DATE (EFFECTIVEDATETO, 'DD/MM/YYYY HH:MM');
Oracle Database
Last Comment
devind
8/22/2022 - Mon
devind
What is the value of EFFECTIVEDATEFROM and EFFECTIVEDATETO ?
GRChandrashekar
ASKER
date time
devind
What i meant was actual value stored in variable/column not the type...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.