What will be the output of below query in MYSQL?

Select current_timestamp as 'Current date';
Select curdate() as 'Current date';

 Posted by vishalneeraj-24503 on 12/4/2013 | Category: Others Interview questions | Views: 1956 | Points: 40
Answer:

Both will produce the same Date but

current_timestamp will produce Current date along-with current time and

curdate will produce Current date only no time.

After executing above query,below output will be displayed.

2013-12-04 15:20:38.833
2013-12-04


There is difference between both in MYSql.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response