How to get only Year from Current Date?

Posted by vishalneeraj-24503 on 12/26/2013 | Category: Sql Server Interview questions | Views: 2019 | Points: 40

Answer:

We will use Year in-built Sql-Server function to get Year from current date.

For Example:-

Select Year(GetDate()) as 'Current Year';

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : Where is the place to assign Read-only variables?

Next > : How to Dispose an Object?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions