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

Answers were Sorted based on User's Feedback



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

Answer / anish mathew

SELECT CURDATE( )

Is This Answer Correct ?    19 Yes 4 No

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

Answer / 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

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

Answer / rohit

SELECT CURRENT_DATE();

Is This Answer Correct ?    6 Yes 2 No

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

Answer / mansukh khandhar

echo date(y/m/d);

Is This Answer Correct ?    0 Yes 1 No

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

Answer / guest

date getset()

u use this query

Is This Answer Correct ?    5 Yes 9 No

Post New Answer

More MySQL Interview Questions

What is meant by mysqli?

0 Answers  


How do I change the max connections in mysql?

0 Answers  


How many threads can mysql handle?

0 Answers  


What is mysqlcheck do?

0 Answers  


Explain the different types of mysql joins.

0 Answers  






change column name and make a unique column so we get no dupes.

0 Answers  


How many primary keys can be there in a table?

0 Answers  


What is mvcc in mysql?

0 Answers  


What is difference between unix timestamp and mysql timestamp?

0 Answers  


How do you determine the location of mysql data directory?

0 Answers  


What is the difference between mysql and sql?

0 Answers  


How do I install mysql on windows 10?

0 Answers  


Categories