Share via

  • Article

YEAR (SSIS Expressions)

Returns an integer that represents the year datepart of a date.

Syntax

YEAR(date)

Arguments

  • date
    Is a date in any date format.

Result Types

DT_I4

Remarks

YEAR returns a null result if the argument is null.

A date literal must be explicitly cast to one of the date data types. For more information, see Integration Services Data Types.

Note

The expression fails to validate when a date literal is explicitly cast to one of these date data types: DT_DBTIMESTAMPOFFSET and DT_DBTIMESTAMP2.

Using the YEAR function is briefer but equivalent to using the DATEPART("Year", date) function.

Examples

This example returns the number of the year in a date literal. If the date is in mm/dd/yyyy format, this example returns "2002".

YEAR((DT_DBTIMESTAMP)"11/23/2002")

This example returns the integer that represents the year in the ModifiedDate column.

YEAR(ModifiedDate)

This example returns the integer that represents the year of the current date.

YEAR(GETDATE())