getting date without timestamp in sql for date column code example

Example 1: sql server current date without time

SELECT CAST (GETDATE() AS DATE)

Example 2: sql datetime as date

SELECT 
    CONVERT(DATE, GETDATE()) date;

Example 3: how to get date in sql

SELECT CURRENT_DATE from dual;