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 mysql_connect?
How to represent ENUMs and SETs internally?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
Where is mysql password stored?
What is the command line end user interface - mysql?
What are the differences between innodb and myisam engines?
How to calculate the difference between two time values?
How can you move the master database
Is mysql same as sql?
How do you name a table?
can you tell how can you display the maximum salary in sql? : Mysql dba
How you will Show unique records.
How does mysql store data?
How can we encrypt and decrypt a data presented in a table using mysql?
What is longblob?