How many ways we can we find the current date using MySQL?
Answer Posted / vikas d.k. gupta
To get the Current Date:-
1. SELECT CURDATE();
2. SELECT CURRENT_DATE();
To get the Current Time:-
1. SELECT CURTIME();
2. SELECT CURRENT_TIME();
To get both at the same time:-
1. SELECT NOW();
2. SELECT SYSDATE();
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What is mysql installer?
how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.
What is mysql connector used for?
What is delimiter $$?
What is the purpose of -> in the mysql terminal?
How do I stop a query in mysql workbench?
Why we use mysql workbench?
How show all tables in mysql query?
What is orm in mysql?
How do I drop a database in mysql?
What is truncate command?
What are the functions used to encrypt and decrypt the data present in mysql?
List some mysql advantages and disadvantages?
Explain the different types of mysql joins.