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 is difference b/w composit key n primary key and forigion key?
what if you really want to store the timestamp data, such as the publication date of the article?
How to Set a root password if there is on root password.
How do I enable mysqli extension?
What is row?
How do I edit a table in mysql?
What, if a table has one column defined as TIMESTAMP?
How do you create a new database in mysql?
What is pragma exception?
What is full form of xampp?
What is the difference between MyISAM Static and MyISAM Dynamic?
What is row level locking in mysql?
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)