xxxxxxxxxx
SELECT current_date FROM dual;-- oracle
SELECT GETDATE(); -- SQL SERVER
SELECT NOW() AS DATETIME; -- Mysql
xxxxxxxxxx
Add GETDATE() in sql query where you want to pass current timestamp.
Example
Return the current database system date and time:
SELECT GETDATE();