Return the current database system date and time:
SELECT GETDATE();
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 theCURRENT_TIMESTAMP function.
GETDATE()
| Return type: | datetime |
|---|---|
| Works in: | SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse |
Author: Kimberely Baumbach CPA
Last Updated:
Views: 6374
Rating: 4 / 5 (61 voted)
Reviews: 92% of readers found this page helpful
Name: Kimberely Baumbach CPA
Birthday: 1996-01-14
Address: 8381 Boyce Course, Imeldachester, ND 74681
Phone: +3571286597580
Job: Product Banking Analyst
Hobby: Cosplaying, Inline skating, Amateur radio, Baton twirling, Mountaineering, Flying, Archery
Introduction: My name is Kimberely Baumbach CPA, I am a gorgeous, bright, charming, encouraging, zealous, lively, good person who loves writing and wants to share my knowledge and understanding with you.