This blog shows how to get the current system date using a SQL query

Example:

SELECT 'CurrDateAndTime', SYSDATETIME()

The expected result would vary based on the time we execute the query

2011-03-03 10:10:12.0861608