MySQL Date and Time Functions

Common Date Functions

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.

Common Date Functions

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;

सारांश

• NOW()/CURDATE() current date/time देते हैं।
• DATEDIFF बीच के दिन निकालता है; DATE_FORMAT output format करता है।