hi sam,
I applied Patch 8.1.7.1.5 and that did the magic, now I can run all queries with to_char conversion.
Thanks a lot