Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL Server SYSDATETIME() Function

Concept visual

SQL Server SYSDATETIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the date and time of the SQL Server:

SELECT SYSDATETIME() AS SysDateTime;

Definition and Usage

The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.

Syntax

Sysdatetime()

Technical Details

Return type:

datetime2(7)

Works in:

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

SQL Server SYSDATETIME() Function

Concept visual

SQL Server SYSDATETIME() Function

Pointer walk

two pointers

left=0

right=6

1

3

Start at both ends

Example

Return the date and time of the SQL Server:

SELECT SYSDATETIME() AS SysDateTime;

Definition and Usage

The SYSDATETIME() function returns the date and time of the computer where the SQL Server is running.

Syntax

Sysdatetime()

Technical Details

Return type:

datetime2(7)

Works in:

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

SQL Server SYSDATETIME() Function

SQL Server SYSDATETIME() Function

Example

Definition and Usage

Syntax

Sysdatetime()

Technical Details

Return type:

Works in:

Previous

Next

SQL Server SYSDATETIME() Function

SQL Server SYSDATETIME() Function

Example

Definition and Usage

Syntax

Sysdatetime()

Technical Details

Return type:

Works in:

Previous

Next