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 |
Explain MySQL architecture?
What are the indexes in mysql?
In which year mysql created?
How do I select a database in mysql?
Can you shard mysql?
How to create a test table in your mysql server?
Where the database is stored in mysql?
How to convert character strings to numeric values?
How can you create and drop view in mysql?
Is blocked because of many connection errors mysql?
Which is faster innodb or myisam?
What are mysql functions?
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)