How many ways we can we find the current date using MySQL?

Question Posted / rajan vardawaj

3 Answers
7535 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many ways we can we find the current date using MySQL?..

Answer / ismail

SELECT CURDATE(),SELECT CURRENT_DATE(),SELECT CURTIME(),
SELECT CURRENT_TIME(),SELECT now().

Is This Answer Correct ?

23 Yes

1 No

How many ways we can we find the current date using MySQL?..

Answer / rajan vardawaj

SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME();
SELECT CURRENT_TIME();

Is This Answer Correct ?

17 Yes

1 No

How many ways we can we find the current date using MySQL?..

Answer / 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