What's the equivalent of Oracle's SYSDATE function in SQL Server?

2012-05-30

Oracle's SYSDATE functions takes no arguments and returns the current date and time to the second.

SELECT SYSDATE AS [CurrentDate] FROM DUAL;

The equivalent of Oracle's SYSDATE function in SQL Server is the GETDATE() function.

SELECT GETDATE() AS [CurrentDate]

The GETDATE() function returns the current date and time to the millisecond.