MSSQL get current datetime

SELECT CURRENT_TIMESTAMP

or

SELECT {fn NOW()}

or

SELECT GETDATE()