GETDATE() is a T-SQL function that returns the current system date and time. {fn {NOW()} on the other hand is an ODBC canonical function which is supported by the SQL Server OLEDB provider. This means, it can also be used in T-SQL.
SELECT GETDATE() and SELECT {fn NOW()} will give the same result.
