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 many tables we can create in mysql database?
How can we repair a MySQL table?
How do I declare a variable in mysql?
What is view? How can you create and drop view in mysql?
What is pragma exception?
How to dump one database for backup.
How many ways we can we find the current date using MySQL?
Can we save images in mysql database?
What different Stored Objects are supported in MySQL?
How do you login to MySql using Unix shell?
How do I run mysql?
How to create a test table in your mysql server?
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)