Example
Return the current database system date and time:
SELECT GETDATE();
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
| Return type: | datetime |
|---|---|
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |