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

Is mysql relational database?

1 Answers  


How to upload a large file through phpmyadmin in mysql?

1 Answers  


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

3 Answers  


how to connect a php script with the mysql database?

1 Answers  


How to get the number of rows selected or affected by a sql statement?

1 Answers  


What is InnoDB?

1 Answers  


Is there a free version of mysql?

1 Answers  


How to load data from a text file into a table?

7 Answers   Sasaa,


how to delete duplicate rows in sql server 2005?

2 Answers   EWIT, Reliance,


Is mysql good for big data?

1 Answers  


How does mysql store dates?

1 Answers  


What do I do if I forgot my mysql root password?

1 Answers  


Categories