I have been asked to convert a script from MSSQL to Oracle but cannot work out how to convert the following line to Oracle.
SELECT CONVERT(varchar, DATEADD(HOUR,DATEDIFF(HOUR, GETUTCDATE(), GETDATE()),CONVERT(varchar,
It should be the difference between UTC and the local time using the time set on the server.