adspace


  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What are the difference between now and current_date in mysql?

Question Posted / hrindows@gmail.com

Answer Posted / hrindows@gmail.com

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 the current mysql version?

1105

Which statement is used in a select query for partial matching?

1247

What is current version of mysql?

1085

How to Change a users password from unix shell.

1223