What is the different between NOW() and CURRENT

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

Question Posted / anand sharma

1 Answers
1560 Views
I also Faced
E-Mail Answers

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

Answer / 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

More MySQL Interview Questions

What is the difference between unix timestamps and mysql timestamps?

0 Answers

How do I switch users in mysql?

0 Answers

What is the use of concat() in mysql?

0 Answers

The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?

4 Answers Afixi, GE,

What is identity in mysql?

0 Answers

What is blob storage?

0 Answers

What is the difference between timestamp and datetime in mysql?

0 Answers

Are stored procedures precompiled?

0 Answers

How many rows can a mysql table hold?

0 Answers

how can you test for null values in a database? : Mysql dba