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

List some mysql advantages and disadvantages?

1011

Is mysql case-sensitive?

945

Why we use mysql workbench?

953

How do you rename a procedure in mysql?

985

What are Heap tables?

1636

Can mysql function return a table?

1141

What is the limitation of mysql?

1012

What does mysql flush tables do?

1008

How do I install mysql workbench?

948

What is the use of mysql_fetch_array () function in php?

998

How MySQL Optimizes DISTINCT?

1165

What are the functions of commit and rollback statements?

1100

Why should I use mysql?

996

What is the use of mysqli_num_rows?

961

What are the two types of queries?

1028