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

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

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

Bookmark It

< Previous : What is the return type of Month in-built sql serv ...

Next > : What is the use of Month in-built Sql-Server funct ...

Comments or Responses

More Interview Questions by Rajesh_Kumar

What is the use of Month in-built Sql-Server function?
How many joins are there in Sql-Server?
What are the types of Cursors?
What considerations must be there when working with Cursors?
How to remove leading space from below string? string name = " ...
How to remove white spaces or empty spaces from within String?
What are Cursors in Sql-Server?
What are the values that @@Fetch_Status Function return while dealing ...

Latest Interview Questions

Write a program using Linq to create a sequence that contains common f ...
What is the output of the following query? var query = from student ...
Which of the following statemet(s) is correct with respact to ArrayLis ...
Can we have different access modifiers for the get and set methods? Ju ...
Can you call a native function that is exported from a dll, if so how?
What is meant by satellite assembly?
How can you define Delay signing?
Is there a possibility to create multilanguage, multifile assembly? If ...
More ...

What will be output of below query? Select Month('01/23/2014') as 'Month';

Comments or Responses

What will be output of below query?

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