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
What is database clustering in mysql?
What is use of mysql?
Write a query to retrieve a hundred books starting from 20th.
How do I declare a variable in mysql?
What are the functions in mysql?
What is the purpose of using ifnull() function?
How does select query work?
How to increment dates by 1 in mysql?
How to delete a trigger in mysql?
What is data node in mysql cluster?
What is text?
What is the storage engine for mysql?
What are the reasons for selecting lamp (linux, apache, mysql, php) instead of combination of other software programs, servers and operating systems?
How do I install mysql on windows 7?
What is meant by mysqli?