DATEPART (SSIS Expression)

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. 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, DT_DBTIMESTAMP2, and DT_DBTIME2.

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