By using now() we can also get the current date for eg:-select * from tbl

How many ways we can we find the current date using MySQL?

Question Posted / lekhrajdeshmukh

Answer Posted / lekhrajdeshmukh

By using now() we can also get the current date
for eg:-select * from tbl_student where
date(sub_date)=date(now());

where sub_date is column name.

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Does facebook still use mysql?

932

What is the difference between myisam dynamic and myisam static in mysql?

1013

How do I flush privileges in mysql?

1006

What is text in mysql?

913

Does mysql scale well?

894

What is heap table?

1029

Is mysql distributed?

932

Why should I use mysql?

941

What is federated tables in mysql?

910

How set mysql root password?

917

How database are managed?

995

Does mysql case matter?

909

How do I run mysql?

1011

What is mysql connection limit?

932

What is longblob in mysql?

968