getdate-ssis-expression.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords
GETDATE (SSIS Expression)	GETDATE (SSIS Expression)	chugugrace	chugu	03/01/2017	sql	integration-services	conceptual	current date GETDATE function dates [Integration Services], GETDATE

GETDATE (SSIS Expression)

[!INCLUDEsqlserver-ssis]

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

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

See Also

GETUTCDATE (SSIS Expression)
Functions (SSIS Expression)