YEAR (SSIS Expression)

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.

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())

See Also

Reference

Other Resources