SQL Server: Current Date Function

Need the current date in your SQL statement? The GETDATE() function is what you're looking for. For example, if you're writing a SELECT statement and you'd like to only return those records in which the field EventDate is in the past, you can write:

WHERE EventDate < GETDATE()

Categories: functions, SQL, SQL Server