how to get current Date in MySQL

it's easy to get current date in MySQL just you need to use  NOW() function 

SELECT NOW() ;

output in my time zone 

2019-10-30 21:27:41

to get a date without time 

SELECT DATE(NOW()) ;

output 

2019-10-30

 

---

answer Link