Convert function not working anymore in OBIEE 12.2.1.3.0

Adam Wickes

Summary

Convert function not working anymore in OBIEE 12.2.1.3.0

Content

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.

Any ideas?

Thanks,
Adam