how to get datetime now in sql code example

Example 1: sql datetime now

SELECT GETDATE();

Example 2: how to to get current date and time in sql

SELECT CURRENT_DATE from dual;