MySQL Date/Time Functions and Conditional Expressions
Date and Time Functions
MySQL provides comprehensive funcsions for extracting and manipulating date and time values.
Retrieving Current Date/Time
-- Get current date and time
SELECT NOW();
-- Returns: YYYY-MM-DD HH:MM:SS
-- Get current date only
SELECT CURDATE();
-- Returns: YYYY-MM-DD
-- Get current time only
SELECT CURTIME();
-- Returns: HH ...
Posted on Wed, 26 Aug 2026 16:11:43 +0000 by darcuss