Desktop productivity for business analysts and programmers

Date error

Accepted Solution Solved
Reply
Contributor
Posts: 25
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
‎07-17-2017 04:35 PM
PROC Star
Posts: 284

Re: Date error

[ Edited ]

this should work

 

to_date('07032017','mmddyyyy')

View solution in original post


All Replies
Super User
Posts: 19,167

Re: Date error

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

 

to_date('07032017','mmddyy10.')

Solution
‎07-17-2017 04:35 PM
PROC Star
Posts: 284

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
  • 84 views
  • 0 likes
  • 3 in conversation