Compass - Date conversion

Legacy Contributor

Hi,

Unable to convert the data to date format. I have used different conversion functions but nothing works. 

Example:

CAST(CAST(RGDT AS VARCHAR(8)) AS DATE)

Error: SQL Error [222]: SQL ERROR Message 222
The value 20210617 is not a valid date.

TO_DATE(CAST(RGDT AS VARCHAR(8)), 'yyyy-MM-dd')

Error: SQL Error [624]: INTERNAL ERROR Message 624
An internal error occurred. Contact Infor Support.
Query ID D2nR3X79CBBC32ff61Ph
Message Details Infor Support personnel will need to research the underlying issue.

per-melander

Try:

convert(datetime, cast(M3IntDateColumn as varchar), 112)