To get the current system date, we use sysdate in Oracle and getdate() in SQL Server, respectively. Using Oracle sqlplus.
SQL> select sysdate from dual; SYSDATE ------------------- 07-22-2014 07:21:21Using SQL Sever Management Studio.
select getdate() 2014-07-22 11:23:23.097