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: 803 | Points: 40

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