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 |
How can you get your MySQL root password, if you lost it?
How can we change the name of a column of a table?
What is the use of pdo?
what is database black box testing? : Mysql dba
How to load data from a text file into a table?
What does TIMESTAMP ON UPDATE CURRENT_TIMESTAMP data type do?
Can mysql and mariadb coexist?
What is pragma autonomous_transaction?
How do I view a mysql database?
how you will Create a database on the mysql server with unix shell.
What are the types of queries?
What port is mysql running on?
Oracle (3259)
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)