By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT CONVERT(date, getdate())
| (No column name) |
|---|
| 2021-07-12 |
SELECT getdate();
| (No column name) |
|---|
| 2021-07-12 21:35:42.097 |
SELECT GETUTCDATE();
| (No column name) |
|---|
| 2021-07-12 20:35:42.097 |