Question
Capgemini
MX
Last activity: 31 Aug 2023 6:09 EDT
Error Convert Text to DateTime in ReportDefinition
Hi All,
I want to convert a text to a DateTime using OOTB Report Definition function but when I run the Report shows:
"Error:
An error occured on executing the query for the report definition - There was a problem getting a list: code: 932 SQLState: 42000 Message: ORA-00932: inconsistent datatypes: expected - got NUMBER DatabaseException caused by prior exception: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got NUMBER | SQL Code: 932 | SQL State: 42000"
I try dates with values format: "YYYY-MM-DD HH:MM:SS", GMT format "yyyyMMddTHHmmss.SSS", in text property but has the same error, also some dates are empty so I try using the function "case when" before "Convert Text to Date" but doesn't seem avaiable.
Can some body help me wich format is correct or tell me what I'm doing wrong?
Regards.
Pegasystems Inc.
GB
It seems you are facing an issue with data type conversion in the Report Definition. The error message indicates an inconsistency between the expected data type and the actual data type.
To resolve this issue, you can try the following steps:
- Ensure that the text format of the date is consistent across all records. If some dates are empty, consider using a default value or handling null values appropriately.
- Use the appropriate OOTB function to convert the text to DateTime. For example, you can use the @ConvertStringToDateTime() function with the correct format, such as "yyyyMMddTHHmmss.SSS" for GMT format.
- If you need to use a conditional expression, you can try using the "case when" statement in the SQL query of the Report Definition, but make sure to handle the data type conversion correctly.
Please double-check the date formats and conversion functions used in your Report Definition to ensure they are consistent and correct.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
How to Convert text to Datetime
Convert Datetime to YYYYMMDD issue: day is incorrect
It seems you are facing an issue with data type conversion in the Report Definition. The error message indicates an inconsistency between the expected data type and the actual data type.
To resolve this issue, you can try the following steps:
- Ensure that the text format of the date is consistent across all records. If some dates are empty, consider using a default value or handling null values appropriately.
- Use the appropriate OOTB function to convert the text to DateTime. For example, you can use the @ConvertStringToDateTime() function with the correct format, such as "yyyyMMddTHHmmss.SSS" for GMT format.
- If you need to use a conditional expression, you can try using the "case when" statement in the SQL query of the Report Definition, but make sure to handle the data type conversion correctly.
Please double-check the date formats and conversion functions used in your Report Definition to ensure they are consistent and correct.
This answer came from a Pega gen-AI assistant using the below references. As a Support Center moderator, I reviewed the answer and references for accuracy:
How to Convert text to Datetime
Convert Datetime to YYYYMMDD issue: day is incorrect
Expression in Report Definition