Hi All,

Currently running SDP 11120, Postgres SQL (installed via SDP installer)

Since upgrading from SDP version 9, one of my query reports isn't working, as it looks to_char in select statement isn't supported anymore, causing an error when trying to run the report (attached).

I had previously used to_char to manipulate the date format, for example:

to_char(to_timestamp(wo.CREATEDTIME / 1000) + interval '10 hour' , 'DD/MM/YY') "Created Date"

Is there a different way to perform the same fuction now?

Cheers