GETUTCDATE (SSIS Expressions)

Returns the current date of the system in UTC time (Universal Time Coordinate or Greenwich Mean Time) using a DT_DBTIMESTAMP format. The GETUTCDATE function takes no arguments.


GETUTCDATE()

DT_DBTIMESTAMP

This example returns the year of the current date in UTC time.

DATEPART("year",GETUTCDATE())

This example returns the number of days between a date in the ModifiedDate column and the current UTC date.

DATEDIFF("dd",ModifiedDate,GETUTCDATE())

This example adds three months to the current UTC date.

DATEADD("Month",3,GETUTCDATE())

Community Additions

ADD
Show: