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: 704 | Points: 40
Answer:

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