Forum Discussion

Fatenodeh's avatar
Fatenodeh
Regular Visitor
5 years ago
Solved

ORA-01843: not a valid month when use to-date

Hello everyone,   I use sql statement to import data from oracle database. I receive "ORA-01843: not a valid month" error when try to connect. there is something wrong with date format but don't k...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    You may be better off asking this in an Oracle SQL forum to help you with that syntax.  T-SQL in SQL Server uses this format, but that is probably specific to their platform.

     

PAVAN515's avatar
PAVAN515
Frequent Visitor
3 years ago

SELECT /*+ INDEX(POLICY_WORK I_AR_DT) */
"TIPS"."POLICY_WORK"."AGENT_ID" AGENT_ID,
SUM(NVL("TIPS"."POLICY_WORK"."ADJ_RATED_EXPSRE_AMT", 0)) RATED_EXPSRE_AMT,
SUM(NVL("TIPS"."POLICY_WORK"."ADJ_PREM_AMT",0)) FUND_PREM,
SUM(NVL(DECODE("TIPS"."POLICY_WORK"."PRMLGTD_AMT","TIPS"."POLICY_WORK"."ADJ_PRMLGTD_AMT",1,0),0)) COUNT
FROM "TIPS"."POLICY_WORK"
WHERE "TIPS"."POLICY_WORK"."AGENT_ID" = :a_agent_id AND
TO_DATE(TO_CHAR( "TIPS"."POLICY_WORK"."AR_DT",'MM/dd/yyyy') ,'MM/dd/yyyy') BETWEEN TO_DATE('01-01-'||TO_CHAR(TO_CHAR(TO_DATE(:a_start_date,'MM/dd/yyyy'),'YYYY')),'MM/dd/yyyy')AND
TO_DATE('01-01-'||TO_CHAR(TO_CHAR(tO_DATE(:a_end_date,'MM/dd/yyyy'),'YYYY')),'MM/dd/yyyy') AND

( "TIPS"."POLICY_WORK"."TRAN_ID" > 999 )
GROUP BY "TIPS"."POLICY_WORK"."AGENT_ID"