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

What are the objects can be created using CREATE statement?

968

How many columns can a mysql table have?

876

How can we encrypt and decrypt a data presented in a table using mysql?

1024

What is back end and front end?

888

What is the storage engine for mysql?

948

What is blob and clob?

930

Write a query to fetch common records between two tables using mysql?

1000

Why are function needed?

915

What is the use of innodb in mysql?

960

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

4648

How to represent ENUMs and SETs internally?

1116

In mysql, what is joins? Explain

951

What are the advantages/disadvantages of mysql and php?

935

how to add a new column to an existing table?

969

Can we create table in stored procedure?

940