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

Can we store images in mysql database?

0 Answers  


what programming language which is used for testing and developement in sql?

3 Answers  


How can you retrieve a portion of any column value by using a select query?

0 Answers  


What is the default port for mysql and how it can change?

0 Answers  


Explain the different types of mysql joins.

0 Answers  


Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.

0 Answers  


How to load a csv file into a table

0 Answers  


How to validate email addresses in mysql?

0 Answers  


How do I drop a database in mysql?

0 Answers  


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

0 Answers  


How is mysql database stored?

0 Answers  


What is data in mysql?

0 Answers  


Categories