SQL Server CURRENT_TIMESTAMP Function

❮ Previous ❮ SQL Server Functions Next ❯

Example

Return the current date and time:

SELECT CURRENT_TIMESTAMP;
Try it Yourself »

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

Technical Details

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

❮ Previous ❮ SQL Server Functions Next ❯
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.