SQL Server 2019 (Linux)

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