DAY (SSIS Expression)
Returns an integer that represents the day datepart of a date.
Syntax
DAY(date)
Arguments
- date
Is an expression that returns a valid date or a string in date format.
Result Types
DT_I4
Remarks
DAY 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 DAY function is briefer but equivalent to using DATEPART("Day", date).
Expression Examples
This example returns the number of the day in a date literal. If the date format is in "mm/dd/yyyy" format, this example returns 23.
DAY((DT_DBTIMESTAMP)"11/23/2002")
This example returns the integer that represents the day in the ModifiedDate column.
DAY(ModifiedDate)
This example returns the integer that represents the day of the current date.
DAY(GETDATE())