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 |
Is mysql relational database?
How to upload a large file through phpmyadmin in mysql?
what programming language which is used for testing and developement in sql?
how to connect a php script with the mysql database?
How to get the number of rows selected or affected by a sql statement?
What is InnoDB?
Is there a free version of mysql?
How to load data from a text file into a table?
how to delete duplicate rows in sql server 2005?
Is mysql good for big data?
How does mysql store dates?
What do I do if I forgot my mysql root password?
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)