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 a tinyint in mysql?

912

How does mysql store binary data?

958

What is pragma serially_reusable and why is it used?

866

Is mysql a scripting language?

895

What is the difference between sql and mysql and oracle?

891

What is the data source name for mysql?

952

What is deterministic in mysql?

980

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1122

How does mysql store data?

941

Where is mysql data stored?

884

How to increment dates by 1 in mysql?

1032

Where is the mysql config file?

984

How do I rename a table in mysql?

975

How you will Show unique records.

1027

What are the differences between char and varchar data types?

1107