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 |
Can we store images in mysql database?
what programming language which is used for testing and developement in sql?
How can you retrieve a portion of any column value by using a select query?
What is the default port for mysql and how it can change?
Explain the different types of mysql joins.
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
How to load a csv file into a table
How to validate email addresses in mysql?
How do I drop a database in mysql?
Transactions are used to treat sets of SQL statements atomically. State Whether True or False?
How is mysql database stored?
What is data in mysql?