eText Output - Converting Date Format
to_char(CHECK_DATE,'DDMMYY') - get 00 for the day
or
to_char(to_date(check_date,'DD-MON-YYYY'),'DDMMYY') - and still get 00 for the day
These both work in Pl/Sql. What is the correct syntax in the eText output.
Thanks!
Karen