how to define a date datatype as string in cymd format

[jerrymoeller]

I need to convert oracle date fields to strings in century,year,month,day format (cymd) to make comparisons to other tables that store date in the cymd format. Is there someone that has experince doing this?

Thanks