CodesJava

Easy learning with example program codes

SYSDATE function in Oracle

SYSDATE is one of the vital Date/Time functions of Oracle. It is used to get the current system date and time on the local database. The result generated is either as a time zone offset or a time zone region name. The SYSDATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.

Syntax:

SYSDATE 

Example:

Select SYSDATE
INTO var
from dual;

Explanation:
The var is a variable that will contain the system’s date and time at the moment of execution.

Please follow and like us:
error









Copyright © 2019 CodesJava DMCA.com Protection Status