Get current datetime

SQL Server:

SELECT GETDATE()

SELECT {fn NOW()}

SELECT CURRENT_TIMESTAMP

Oracle:

SELECT SYSDATE AS Now FROM dual;

SELECT CURRENT_DATE AS Now FROM dual;

Reference
http://msdn2.microsoft.com/en-us/library/ms187928.aspx
http://www.psoug.org/reference/date_func.html