Getting current system time in SQL Server

Question

How do I get current system time in SQL Server?

Answer 1

Use the GETDATE() function

SELECT GETDATE()

Answer 2

CURRENT_TIMESTAMP is ANSI compliant and equivalent to GETDATE()

Otherwise, you have a plethora of functions as mentioned in SQL Server 2008 BOL here (with link for SQL Server 2005 too).

I think marc_s might have missed 1 or 2 ;-)