CURRENT_TIMESTAMP is valid syntax for both SQL Server and Oracle. Oracle will return the current date and time in the session time zone. SQL Server will return the current date and time of the Operating System
You could also just alias it in t-sql to match Oracle's function?
CREATE FUNCTION sysdate ()RETURNS DATETIMEASBEGIN RETURN getdate()ENDGO