Casting Datetime to Vacahar Datatype

EVALUATE('TO_CHAR(%1,%2)' as char ,table.date,'dd/mm/yyyy HH24:MI:SS')
Where table.date is the table.column you want to convert to char, chose the timestamp according to your data.

Until Next Post... :)