Convert function not working anymore in OBIEE 12.2.1.3.0
Summary
Convert function not working anymore in OBIEE 12.2.1.3.0Content
Hi all,
We have a number of reports that utilise the T-SQL convert function with a style of 112.
In a lot of these reports, we also convert the date parameter as follows:
select convert(datetime, :AParameter, 112) as datefield1 from table
In 11g, this works fine.
In 12c, we get the following error when attempting to save sample data:
and this in the engine log:
[180503_02290043][DATA PROCESSOR ID:809564989][SCH JOB INFO:]XMLPGEN:[FMWGEN][SQLServer JDBC Driver][SQLServer]The style 112 is not supported for conversions from datetimeoffset to date.[180503_02290043][DATA PROCESSOR ID:809564989][SCH JOB INFO:]java.sql.SQLException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The style 112 is not supported for conversions from datetimeoffset to date.
0