MySQL CURTIME Function

Friday, December 23, 2011

tags SQL

The MySQL CURTIME function is used to display the current time. The equivalent function in Microsoft SQL Server is GETDATE, but would require formatting with the CONVERT function.

Syntax

CURTIME()


Example
SELECT CURTIME() as [Time]


Results

Time
20:15:05

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

Recommended Books & Training Resources

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