What is the difference between Now() and Current_Timestamp() function in MySql?

 Posted by vishalneeraj-24503 on 12/5/2013 | Category: Sql Server Interview questions | Views: 4742 | Points: 40
Answer:

There is NO difference between Now() and Current_Timestamp() function in MySql.
Both produces the same output as Current Date and Time as the system date as a string in the form of "YYYY-MM-DD HH:MM:DD".

For ex:-

Select Now() as 'Current Time';
Select Current_Timestamp() as 'Current Time';


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response