What is the different between NOW() and CURRENT_DATE()?

Answer Posted / shiwanshu

Now() Show the current date with time with AM/PM
Current_date () show only the current_date

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do stored procedures work?

488


What is 1nf 2nf 3nf?

508


Why is it called mysql?

510


How can I remotely connect to mysql database?

452


Can we use mysql and mysqli together?

509






What is data type for image in mysql?

457


How to enter microseconds in sql statements?

524


Why should I use mysql?

506


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2424


Is sqlite faster than mysql?

496


How do I enable mysqli extension?

499


What is the difference between timestamp and datetime in mysql?

556


What is regexp?

660


What is a storage engine? What are the differences between innodb and myisam engines?

518


Explain the different types of mysql joins.

498