Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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())