SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL

For Complete YouTube Video: Click Here

In this class, we will understand SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL.

We have already covered the concepts of number functions.

Table of Contents

The SYSDATE function will get the date on the machine upon which the DBMS software is located.

SELECT SYSDATE FROM DUAL;

The output of the query is as shown below.

The CURRENT_DATE function will get the date on the user machine.

SELECT CURRENT_DATE FROM DUAL;

The output of the query is as shown below.

As the DBMS software location and the user machine are the same, we will get the same result.

The SYSTIMESTAMP function will get the time on the machine upon which the DBMS software is located.

SELECT SYSTIMESTAMP FROM DUAL;

The output of the query is as shown below.