Converting datetime value into year value

• Mark Green

  SSCrazy

  Points: 2085

  More actions

  June 15, 2006 at 5:33 am

  #114018

  How do I convert a datetime value into just the 4 digit year?

• Paul Anderson-304005

  SSC-Addicted

  Points: 451

  More actions

  June 15, 2006 at 5:37 am

  #643918

  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: 39725

  More actions

  June 15, 2006 at 5:41 am

  #643919

  Or simply

  SELECT YEAR(MyField) FROM MyTable

  ---

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