How many ways we can we find the current date using MySQL?
Answers were Sorted based on User's Feedback
Answer / ismail
SELECT CURDATE(),SELECT CURRENT_DATE(),SELECT CURTIME(),
SELECT CURRENT_TIME(),SELECT now().
Is This Answer Correct ? | 23 Yes | 1 No |
Answer / rajan vardawaj
SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME();
SELECT CURRENT_TIME();
Is This Answer Correct ? | 17 Yes | 1 No |
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 |
about join
How do I make an action query?
What does mysql_query return?
what is constraints?
Write a program using the select statement, while loop.
How large can a mysql database become?
how to declare unique key in creating a table..?
How do I use mysql?
How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.
What is the purpose of -> in the mysql terminal?
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
what is the procedure to configure the application of mysql?