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
Here is my sample code:
SELECT startdate, OrderNumber
FROM Orders
ORDER BY startdate
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER