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 |
How to get nth highest salary from table in a mysql?
What is dblink?
What is the difference between truncate and delete in mysql?
what is the difference between between and in operators in mysql?
Can you tell how many values can set the function of mysql to consider?
Can mysql handle billions of records?
Does mysql support nosql?
Does mysql support sequence?
How do you create a new database in mysql?
Explain the difference between mysql and mysql interfaces in php?
What is the use of mysqli_num_rows?
What is a definer?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)