Desktop productivity for business analysts and programmers

Date error

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 17
Accepted Solution

Date error

Hi

 

I am having trouble idenifying an error, its says an oracle error which Ive never seen before

 

ADR.ST_CD in ('MO','TX','WA','AL','KY','MD','MI','OR','NJ') and AC.CREAT_DTTM >= to_date('07032017','mmddyy10.') and P.ENRL_DT is
not null and P.PGM_CATGY_TYP_ID in ('04') and P.PGM_TYP_ID not in ('52','04') and P.MBR_PGM_STS_RSN_TYP_ID = '81' and
P.MBR_PGM_STS_TYP_ID = '05' and p.mbr_id = adr.mbr_id and p.mbr_id = ac.mbr_id and adr.mbr_id = ac.mbr_id ORDER BY M.MBR_ID ) as K ;
NOTE: Compression was disabled for data set INPUT.CLIENT_ICUE_SELECTION because compression overhead would increase the size of the
      data set.
ERROR: Error fetching from cursor. ORACLE error is ORA-01821: date format not recognized.

 

Thanks

 

Rida


Accepted Solutions
Solution
Monday
Regular Contributor
Posts: 228

Re: Date error

[ Edited ]

this should work

 

to_date('07032017','mmddyyyy')

View solution in original post


All Replies
Grand Advisor
Posts: 17,325

Re: Date error

I don't know ORACLE but I'd guess on this being the error:

 

to_date('07032017','mmddyy10.')

Solution
Monday
Regular Contributor
Posts: 228

Re: Date error

[ Edited ]

this should work

 

to_date('07032017','mmddyyyy')

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 69 views
  • 0 likes
  • 3 in conversation