sql dateonly code example Example 1: sql datetime as date Click to copySELECT CONVERT(DATE, GETDATE()) date; Example 2: sql display today's date Click to copySELECT getdate()