Converting datetime value into year value

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Paul Anderson-304005 SSC-Addicted Points: 451 More actions · Answer 1

You can use DATENAME function to do this. This will do it for the current date.

SELECT DATENAME( year, GetDate() )

Or in a query

SELECT DATENAME( year, <ColumnName> )

FROM <TableName>

Where Column name is the name of the column and Table name is the name of the table.

Andez

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 2

Or simply

SELECT YEAR(MyField) FROM MyTable

N 56°04'39.16"
E 12°55'05.25"

Cookies on SQLServerCentral