Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways we can we find the current date using MySQL?
- 3 Answers
- 8870 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
What is mysql database used for?
How to drop an existing table in mysql?
What is inner join in mysql?
What is mysql common?
How do I clear the command in mysql?
What is meant by sharding?
Is mysql from oracle?
What is pdo in php mysql?
What is delimiter in mysql trigger?
What is text in mysql?
How do I fix a crashed mysql database?
What does mysql_fetch_assoc do?
Which statement is used to delete a table in MySQL.
What is definer in mysql?
What is bigint in mysql?
