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 |
Which software is used for mysql?
What is the return type of mysqli_query?
What is the password of mysql?
Explain MySQL architecture?
Is mysqli secure?
Can you shard mysql?
How to enter boolean values in sql statements?
Is mysql easy to learn?
What is the difference between GROUP BY and ORDER BY in Sql?
12 Answers Creative, Renault Nissan, Trikon Networks,
What ascii 31?
Can we create table in stored procedure?
What is InnoDB?
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)