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 many values can the SET function of MySQL take?
2 Answers Creative Informatics,
What is pdo in php mysql?
What is mysql cursor?
What is the difference between the LIKE and REGEXP operators?
What is a mysql model?
What is the purpose of mysql database?
What is triggers?
What is mysql data directory? How to determine the location of the data directory?
Will mysql remain free?
How to use in conditions?
Are stored procedures precompiled?
How to create and drop view in mysql?
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)