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 the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

0 Answers  


What does schema mean?

0 Answers  


what is the difference between MyIsam and InnoDb engine?

2 Answers  


Explain MySQL locks?

1 Answers  


If we create a column with data type VARCHAR(3), what would we expect to see in MySQL table?

2 Answers   ABC,






What is acid in mysql?

0 Answers  


Explain the difference between delete and truncate.

0 Answers  


What is limit in mysql?

0 Answers  


What is dblink?

0 Answers  


Can you tell a way to know the number of days between the two given dates in php?

0 Answers  


how we connect the data base in any programme

2 Answers  


What is database url for mysql?

0 Answers  


Categories