What are the difference between now and current_date in mysql?



What are the difference between now and current_date in mysql?..

Answer / hrindows@gmail.com

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

Post New Answer

More MySQL Interview Questions

How to copy data from one server to another using php?

0 Answers  


How do I backup mysql database on linux?

0 Answers  


how we can find nth max salary from an employe table by using my sql?

8 Answers  


can you tell how can you display the maximum salary in sql? : Mysql dba

0 Answers  


can you tell the order of sql select statement? : Mysql dba

0 Answers  


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

0 Answers   ACC,


How do I restore a database in mysql workbench?

0 Answers  


Why do we need mysql?

0 Answers  


How to enter Characters as HEX Numbers?

0 Answers  


What is MySQL Stored Procedure?

1 Answers  


What is mysql in dbms?

0 Answers  


Can we store images in mysql database?

0 Answers  


Categories