how to retrieve date 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;