How many ways we can we find the current date using MySQL?
- 3 Answers
- 7519 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 the latest version of php and mysql?
How to use regular expression in pattern match conditions?
What is acid in mysql?
How to decrement dates by 1 in mysql?
What is mysql_pconnect?
How to check if value already exists in mysql database in php?
how to take mysql database backup?
What is difference between mysql mysqli and pdo?
Is sqlite faster than mysql?
What is the difference between a heap table and temporary table?
What is mysql server?
What is localhost in mysql?
How many primary keys can be there in a table?
How do I quit mysql?
What is mysql community server?
