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