What will be output of below query?

Select Month('01/23/2014') as 'Month';

 Posted by Rajesh_Kumar on 1/23/2014 | Category: Sql Server Interview questions | Views: 1961 | Points: 40

Output will be 1,because Month in-built sql server function will extract only month part from any date.Here month is 01 i.e. Jan,so it will return 1.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response