TO_CHAR conversion (Oracle -> SQL Server)

[kfordaccela]

“Oracle” to “SQL Server” TO_CHAR is not being converted to a “CAST” or “CONVERT” as it should be. This is consistent online as well as in the Command line program.

Input given:

SELECT TO_CHAR(COALESCE(GPH2.SD_APP_DD,SYSDATE),'MM/DD/YYYY') reportdate
FROM DUAL GPH2

Output that was returned:
SELECT TO_CHAR(COALESCE(GPH2.SD_APP_DD,GETDATE()),'MM/DD/YYYY') reportdate

Version used to check locally: SQLines 3.1.113 - Windows 32-bit, 5.3 MB, July 02, 2018 (Most Recent Windows Release for SQL conversion only)