How many ways we can we find the current date using MySQL?
Answers were Sorted based on User's Feedback
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 |
What is meant by mysqli?
How do I change the max connections in mysql?
How many threads can mysql handle?
What is mysqlcheck do?
Explain the different types of mysql joins.
change column name and make a unique column so we get no dupes.
How many primary keys can be there in a table?
What is mvcc in mysql?
What is difference between unix timestamp and mysql timestamp?
How do you determine the location of mysql data directory?
What is the difference between mysql and sql?
How do I install mysql on windows 10?