how to get data by date time in sql code example

Example 1: how to find date from date table in sql

SELECT CONVERT(date, getdate());

Example 2: how to get date in sql

SELECT CURRENT_DATE from dual;