DAY (SSIS)
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.
Using the DAY function is briefer but equivalent to using DATEPART("Day", date).
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())
See Also
Reference
DATEADD (SSIS)
DATEDIFF (SSIS)
DATEPART (SSIS)
MONTH (SSIS)
YEAR (SSIS)