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 ascii 31?
How to connect html form to mysql database using php?
How to get nth highest salary from table in a mysql?
What is striped backup
How does mysql store data?
What are the features of mysql?
What are the differences between char and nchar?
How do you say mysql?
What are the advantages/disadvantages of mysql and php?
What is required to create mysql database?
How can I compare two mysql databases?
What is the purpose of using timestamp data type?
Oracle (3253)
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)