GETDATE (SSIS Expressions)

GETDATE (SSIS Expressions)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Other versions are also available for the following:

SQL Server 2008 Books Online (June 2009)

GETDATE (SSIS Expressions)

Returns the current date of the system in a DT_DBTIMESTAMP format. The GETDATE function takes no arguments.

Note:
The length of the return result from the GETDATE function is 29 characters.

Syntax

GETDATE()

Arguments

None

Result Types

DT_DBTIMESTAMP

Examples

This example returns the year of the current date.

DATEPART("year",GETDATE())

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

DATEDIFF("dd",ModifiedDate,GETDATE())

This example adds three months to the current date.

DATEADD("Month",3,GETDATE())