YEAR (SSIS Expression)
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
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.
Expression 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
DATEADD (SSIS Expression)
DATEDIFF (SSIS Expression)
DATEPART (SSIS Expression)
DAY (SSIS Expression)
MONTH (SSIS Expression)
Functions (SSIS Expression)
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om