Answers for "how to query something on mysql based on date"

mysql query date year

SELECT book_name,dt_of_pub,YEAR(dt_of_pub)
FROM book_mast
WHERE YEAR(dt_of_pub)>2003;

Posted by: Guest on June-14-2020

where date in datetime mysql

WHERE DATE(datetime) = '2009-10-20'
like this
WHERE datetime LIKE '2009-10-20%'

Posted by: Guest on September-03-2021

Code answers related to "how to query something on mysql based on date"