"TO_CHAR" is not recognized: with crmConvertDateToChar
When crmConvertDateToChar is used it throws an exception and does not work with SQL Server.
This occurs with Pega Customer Service for Healthcare 7.22.
"TO_CHAR" is not recognized
Steps to Reproduce
- Create a report definition.
- Set the function "crmConvertDateToChar" in column with a property Datetime.
This is an Oracle specific function, the TO_CHAR will work Oracle and DB2 which have equivalent functions at the database level, this is not available for SQL Server.
A custom function will have to be written if a TO_CHAR is required for use with SQL Server.
There are examples on how to do this in the PDN and help files:
SQL Server which uses the CONVERT function to achieve the same thing as TO_CHAR but uses 3 parameters instead of 2 with the following format
CONVERT(TYPE, DATE, STYLE)
Refer to SQL Server documentation for further information on this function.
0% found this useful