how to get dates in sql table 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;