| Viewed 198 times

how to get current Date in MySQL

how to get current Date in MySQL

MySql
1 Answer
Mohammad Qandeel
Answered
22

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

 

Related Questions