MySQL + SQL · Lesson 58

MySQL Date and Time Functions

Common Date Functions

FunctionReturns
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.
🔗

Share this topic with a friend

यह topic किसी दोस्त को भेजें

Found it useful? Send it to a classmate learning the same thing.

अच्छा लगा? जो दोस्त यही सीख रहा है, उसे भेज दीजिए।

💻 Live Code Editor

This page's programs are ready here — run them, edit them, and learn. No installation needed.
Powered by OneCompiler. The code loads into the editor automatically — press Run to see the output. If the editor does not open, open it in a new tab.