Now() Show the current date with time with AM/PM Current

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

Question Posted / shiwanshu

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

Please Help Members By Posting Answers For Below Questions

How do I run mysql on a mac?

971

What are date and time functions in mysql?

1014

How do I change directories in mysql?

910

How to define numeric 9(3) in db2 table without decimal point??

2852

What is the usage of "i-am-a-dummy" flag in mysql?

1140

How to Change a users password from unix shell.

1124

What is the difference between database and table?

1009

What is cursor in mysql?

898

How do you rename a table?

999

What are the method you will follow while sql installing

2366

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

1069

How do I start and stop mysql on windows?

1010

Is mysql same as sql?

900

Is mysql owned by oracle?

1019

How to change a password for an existing user via mysqladmin?

985