DATEPART (SSIS)
Returns an integer representing a datepart of a date.
Syntax
DATEPART(datepart, date)
Arguments
- datepart
Is the parameter that specifies for which part of the date to return a new value.
- date
Is an expression that returns a valid date or a string in date format.
Result Types
DT_I4
Remarks
DATEPART returns a null result if the argument is null.
A date literal must be explicitly cast to one of the date data types.
The following table lists the dateparts and abbreviations recognized by the expression evaluator. Datepart names are not case sensitive.
| Datepart | Abbreviations |
|---|---|
Year |
yy, yyyy |
Quarter |
qq, q |
Month |
mm, m |
Dayofyear |
dy, y |
Day |
dd, d |
Week |
wk, ww |
Weekday |
dw, w |
Hour |
Hh |
Minute |
mi, n |
Second |
ss, s |
Millisecond |
Ms |
Examples
This example returns the integer that represents the month in a date literal. If the date is in mm/dd/yyyy" format, this example returns 11.
DATEPART("month", (DT_DBTIMESTAMP)"11/04/2002")
This example returns the integer that represents the day in the ModifiedDate column.
DATEPART("dd", ModifiedDate)
This example returns the integer that represents the year of the current date.
DATEPART("yy",GETDATE())
See Also
Reference
DATEADD (SSIS)
DATEDIFF (SSIS)
DAY (SSIS)
MONTH (SSIS)
YEAR (SSIS)
Other Resources
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|