| Viewed 16 times

how to get current Date in MySQL


how to get current Date in MySQL

1 Answer
Mohammad Qandeel
Answered
0

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