NOW NOW() give you the curren

What are the difference between now and current_date in mysql?

Question Posted / hrindows@gmail.com

1 Answers
1391 Views
I also Faced
E-Mail Answers

NOW
NOW() give you the current date time in the format 'YYYY-MM_DD HH:MM: SS'
CURRENT
CURRENT_DATE() will only give you the current date in format "YYYY-MM_DD"

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is clob in mysql

928

How do I change global variables in mysql?

879

Write a command to list all databases in mysql?

1021

What is a text delimiter?

910

How do I start and stop mysql server?

976

How to execute mysql query in php?

894

How do I copy an entire mysql database?

864

Can mysql handle billions of records?

1047

What are the differences between char and varchar data types?

1072

What is new mysqli?

903

How do I create a new database in mysql?

888

What are the technical specifications of mysql?

1139

What is the command line end user interface - mysql?

1055

How will you export tables as an xml file in mysql?

874

How do I show columns in mysql?

913