What will be the output of below query in SQL-SERVER?

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

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

Both will produce the same output meaning after executing above query,below output will be displayed.

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


There is No difference between both in sql-server.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response