This content has been marked as final. Show 2 replies
Why dont you use Evaluate function?
EVALUATE('TO_DATE(%1,%2)' as date,yourvarcharcolumn, 'dd-mm-yyyy')
The original post is 4 years old - I am sure the poster must have figured it out by this time... obiee 11g supports a To_Datetime function though! thanks!