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

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

More MySQL Interview Questions

about join

2 Answers  


How do I make an action query?

0 Answers  


What does mysql_query return?

0 Answers  


what is constraints?

0 Answers  


Write a program using the select statement, while loop.

0 Answers  






How large can a mysql database become?

0 Answers  


how to declare unique key in creating a table..?

2 Answers  


How do I use mysql?

0 Answers  


How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

0 Answers  


What is the purpose of -> in the mysql terminal?

0 Answers  


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

0 Answers  


what is the procedure to configure the application of mysql?

0 Answers  


Categories