today() sql code example
Example 1: sql current date
Add GETDATE() in sql query where you want to pass current timestamp.
Example
Return the current database system date and time:
SELECT GETDATE();
Example 2: current date in sql
SELECT CURRENT_DATE from dual;