GETUTCDATE (SSIS)

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.

Syntax

GETUTCDATE()

Arguments

None

Result Types

DT_DBTIMESTAMP

Examples

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

See Also

Reference

GETDATE (SSIS)

Other Resources

Functions (SSIS)

Help and Information

Getting SQL Server 2005 Assistance