SQL•SQL References

SQL Server CURRENT_TIMESTAMP Function

Example

SELECT
CURRENT_TIMESTAMP;

Definition and Usage

The CURRENT_TIMESTAMP function returns the current date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

Tip

Also look at the GETDATE() function.

Syntax

CURRENT_TIMESTAMP

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

Loading lesson path

SQL•SQL References

Example

SELECT
CURRENT_TIMESTAMP;

The CURRENT_TIMESTAMP function returns the current date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

Tip

Also look at the GETDATE() function.

Syntax

CURRENT_TIMESTAMP

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