How many ways we can we find the current date using MySQL?
Answer Posted / 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 |
Post New Answer View All Answers
What is data node in mysql cluster?
How do we delete a row in a table?
How do I backup mysql database on linux?
Is oracle better than mysql?
What is a mysql model?
What is difference between mysql and mysql workbench?
In which year mysql created?
How does mysql encrypt passwords?
What is a tinyint?
Where’s database data actually stored?
What are the different data types in mysql?
What is cast in mysql?
Explain the difference between primary key and candidate key in mysql?
How to load data files into tables with 'mysqlimport'?
why not null is not allowed at table level