How to Get the Current Date and Time in SQL Server
Last updated July 25, 2026 · By the SaturnSQL team
GETDATE() returns the current local datetime, SYSDATETIME() the same at datetime2 precision, and GETUTCDATE()/SYSUTCDATETIME() the UTC equivalents. CAST to date when you only want the day.
SELECT GETDATE(), SYSDATETIME(), GETUTCDATE(), SYSUTCDATETIME();Today's date without the time
SELECT CAST(GETDATE() AS date) AS today;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free