How to Get the Current Date and Time in MySQL

Last updated July 24, 2026 · By the SaturnSQL team

NOW() returns the current datetime, CURDATE() the date, and CURRENT_TIMESTAMP is standard-SQL spelling for NOW(). Use DATE_SUB/DATE_ADD and DATE_FORMAT for offsets and formatting.

SELECT NOW(), CURDATE(), CURRENT_TIMESTAMP;

SELECT
  DATE_SUB(CURDATE(), INTERVAL 1 DAY) AS yesterday,
  DATE_SUB(CURDATE(), INTERVAL 30 DAY) AS thirty_days_ago;