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 |
Explain the difference between mysql and mysql interfaces in php?
What is a data directory?
Which one of the following is the correct way to select all columns and all rows from "vtable"? Choice 1 SELECT FROM vtable SELF JOIN vtable Choice 2 SELECT ALL COLUMNS FROM vtable WHERE ALL ROWS = * Choice 3 SELECT EVERYTHING FROM vtable Choice 4 SELECT vtable.* WHERE vtable = vtable Choice 5 SELECT * FROM vtable WHERE 1 = 1
Consider you have the following three tables which have to be linked together.
What is mysql database used for?
How does mysql store binary data?
write a command to view the content of the table
Is mysql from oracle?
How do I fix a crashed mysql database?
How do you control the max size of a HEAP table?
Can I use mariadb instead of mysql?
How do I backup mysql database on linux?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)