Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways we can we find the current date using MySQL?
- 3 Answers
- 8718 Views
- I also Faced
- E-Mail Answers
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
How do I know if mysql is installed on windows?
How do I select a database in mysql?
How to shutdown mysql server?
What is the difference between the primary and unique key in mysql?
What are the benefits of mysql?
What is innodb mysql?
What is procedural api?
Which is faster mongodb or mysql?
How to Set a root password if there is on root password.
How to show table structure mysql?
How to run 'mysql' commands from a batch file?
What is the function of mysqldump?
What is MySQL?
How do I save in mysql?
How do I find users in mysql?
