What are the difference between now and current_date in mysql?
- 1 Answers
- 640 Views
- I also Faced
- E-Mail Answers
What are the difference between now and current_date in mysql?..
NOW
NOW() give you the current date time in the format 'YYYY-MM_DD HH:MM: SS'
CURRENT
CURRENT_DATE() will only give you the current date in format "YYYY-MM_DD"
| Is This Answer Correct ? | 0 Yes | 0 No |
More MySQL Interview Questions
How do I start mysql in mysql workbench?
What are string data types?
What is memory table in mysql?
How would you get the current date in mysql?
How do I edit a table in mysql?
What are the difference between and myisam and innodb?
What is longblob in mysql?
What is the purpose of using ifnull() function?
Is pdo faster than mysqli?
Is pdo more secure than mysqli?
What does tinyint mean?
What is innodb mysql?
Categories
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
