🔥 Basic Date-Time Questions in MySQL

Jun 13, 2025 by codewithhemu

1.Fetch today’s records

SELECT * FROM table WHERE DATE(col)=CURDATE();

SELECT * FROM table WHERE col >= CURDATE()-INTERVAL 1 DAY AND col < CURDATE();

SELECT * FROM table WHERE MONTH(col)=MONTH(CURDATE()) AND YEAR(col)=YEAR(CURDATE());

WHERE col >= CURDATE() - INTERVAL 7 DAY

SELECT MONTHNAME(col) FROM table;

WHERE DAYOFWEEK(col)=2

SELECT TIMEDIFF(time_end, time_start)FROM table;

WHERE MONTH(birthdate)=MONTH(CURDATE()) AND DAY(birthdate)=DAY(CURDATE())

SELECT DATE(col) FROM table;