mysql query date year
snippet in sql

mysql query date year

user3389

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