SQL 2005 - Display YEAR only in date column

I need only the YEAR displayed from a date column. This is going into a new SQL 2005 view.

Here is my sample code:
SELECT  startdate, OrderNumber
FROM Orders
ORDER BY startdate
allenkentAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
SELECT  year(startdate) startdate, OrderNumber
FROM Orders
ORDER BY startdate
0
 
allenkentAuthor Commented:
That was easy.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.