MySQL CURDATE Function

Thursday, December 22, 2011

tags SQL

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

Date
2011-12-13

Did you find the page informational and useful? Share it using one of your favorite social sites.

Recommended Books & Training Resources

Head First SQL: Your Brain on SQL A Learners Guide SQL Cookbook