Tuesday, July 22, 2014

Get Current Date In Oracle and Server SQL

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:21
Using SQL Sever Management Studio.
select getdate()
2014-07-22 11:23:23.097

No comments: