GETUTCDATE (SSIS Expression)
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
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
Expression 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
Athugasemdir
https://aka.ms/ContentUserFeedback.
Væntanlegt: Á árinu 2024 munum við hætta með GitHub-mál sem ábendingaleið fyrir efni og skipta því út fyrir nýtt ábendingakerfi. Frekari upplýsingar er að finna hér:Senda inn og skoða endurgjöf fyrir