The MySQL CURDATE function is used to display the current date. The equivalent function in Microsoft SQL Server is GETDATE, but would require formatting with the CONVERT function.
Syntax
CURDATE()
Example
SELECT CURDATE() as [Date]
Results
2011-12-13











