Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

DATEPART (SSIS)

Updated: 5 December 2005

Returns an integer representing a datepart of a date.


DATEPART(datepart, date)
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.

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

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

Release History

5 December 2005

New content:
  • Added table of dateparts and abbreviations that you can use with the DATEPART function.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.