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

What is latest version of mysql?

1081

What is save point in mysql?

1005

What language is used in mysql?

1044

What is blob storage?

1042

How to shut down the server with 'mysqladmin'?

1028

what is constraints?

1241

What are the difference between and myisam and innodb?

1088

Is mysql is a programming language?

1042

How many ways to get the current time?

1013

How to show table names with 'mysqlshow'?

1080

How we can create index in mysql?

1027

How can I create table in mysql?

1092

What is a join? Explain the different types of mysql joins.

1464

How to extract a unit value from a date and time?

1005

Explain % and _ inside like statement?

1080