Interested to Buy Any Domain ? << Click Here >> for more details...
How many ways we can we find the current date using MySQL?
- 3 Answers
- 8964 Views
- I also Faced
- E-Mail Answers
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 do you rename a procedure in mysql?
What is trigger in mysql with example?
How many sql dml commands are supported by 'mysql'?
How can an index be declared in mysql?
In which format data is stored in mysql database?
How many services is running in sql server?
Where is the mysql data directory?
HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE
How to delete an existing column in a table?
What is a scalar function?
What is insert query in mysql?
What is meant by sharding?
-
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)
