THE WORLD'S LARGEST WEB DEVELOPER SITE

SQL Server GETDATE() Function

❮ SQL Server Functions

Example

Return the current database system date and time:

SELECT GETDATE();
Try it Yourself »

Definition and Usage

The GETDATE() function returns the current database system date and time, in a 'YYYY-MM-DD hh:mm:ss.mmm' format.

Tip: Also look at the CURRENT_TIMESTAMP function.

Syntax

GETDATE()

Technical Details

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

❮ SQL Server Functions