Hi All,
I am getting the below error when i use the to_char function in report studio.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
UDA-SQL-0219 The function to_char is not available as an external, database, or built-in function
My requirement is, i am having a table which contains the user id, user name, and date format, time format.
for each user id there have specific date format(stirng values like 'dd-MON-yyyy', dd-mon-yyyy') defined in that table.
I am trying to use the dateformat column in to_char as below.
to_char([date column from fact table],[date format for the user logged in])
when i try to run i am getting the error.
but fyi below expression working fine.
to_char({sysdate}, [date format for the user logged in]) -WORKING FINE.
Thanks ,
eas