MySQL + SQL · Lesson 58
MySQL Date and Time Functions
Common Date Functions
| Function | Returns |
|---|---|
| NOW() | current date + time |
| CURDATE() | current date |
| YEAR()/MONTH()/DAY() | part of a date |
| DATEDIFF(a,b) | days between |
| DATE_FORMAT() | format a date |
Examples
SELECT NOW(), CURDATE();
SELECT name, DATEDIFF(CURDATE(), admission_date) AS days_enrolled
FROM students;
SELECT DATE_FORMAT(admission_date, '%d-%m-%Y') FROM students;Summary
- NOW()/CURDATE() give current date/time.
- DATEDIFF finds days between; DATE_FORMAT formats output.