Answers for "NOW()+year mysql"

use of now() in mysql

NOW() : It will return current date and time. 

Ex: select NOW(); 	//YYYY-MM-DD HH-MM:SS

Output: 2021-09-13 15:35:41

Posted by: Guest on September-13-2021

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

Code answers related to "NOW()+year mysql"