Hello.

We just upgraded from SDP 9.3 to 11.1 (Build 11115), and I'm now finding that custom MSSQL queries are no longer converting date fields such as Notes.NOTESDATE to Date/Time format using the "FROM_UNIXTIME" function.

For instance, the following SQL used to work:

But now I get an error on the "dbo.from_unixtime..." line.  (When commenting out that line, the above SQL works as expected.)

I tried adding the database name in front (servicedeskplus.dbo.from_unixtime...) and also tried removing the "dbo." and just going with "from_unixtime", but neither of those worked, either.

In doing some investigation in SQL Server Management Studio, I saw that we used to have a Scalar-valued Function of dbo.from_unixtime in our old database (as well as other Scalar-valued Functions), but I'm not seeing any Scalar-valued Functions in our new database.

Do I need to modify our SQL queries to convert fields like Notes.NOTESDATE some other way now that we've upgraded?

-- Russ

Version 11.1 (Build 11115)

MSSQL