Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL Server GETUTCDATE() Function

Concept visual

SQL Server GETUTCDATE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current UTC date and time:

Select

GETUTCDATE();

Definition and Usage

The GETUTCDATE() function returns the current database system UTC date and time, in a

Formula

'YYYY - MM - DD hh:mm:ss.mmm' format.

Syntax

Getutcdate()

Technical Details

Return type:

datetime

Works in:

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

SQL Server GETUTCDATE() Function

Concept visual

SQL Server GETUTCDATE() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the current UTC date and time:

Select

GETUTCDATE();

Definition and Usage

The GETUTCDATE() function returns the current database system UTC date and time, in a

Formula

'YYYY - MM - DD hh:mm:ss.mmm' format.

Syntax

Getutcdate()

Technical Details

Return type:

datetime

Works in:

SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

SQL Server GETUTCDATE() Function

SQL Server GETUTCDATE() Function

Example

Select

Definition and Usage

Syntax

Getutcdate()

Technical Details

Return type:

Works in:

Previous

Next

SQL Server GETUTCDATE() Function

SQL Server GETUTCDATE() Function

Example

Select

Definition and Usage

Syntax

Getutcdate()

Technical Details

Return type:

Works in:

Previous

Next