Скачать или смотреть SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL || Lesson 65 || DBMS || Learning Monkey ||

SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL

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

We have already covered the concepts of number functions.

SYSDATE CURRENT_DATE SYSTIMESTAMP Functions in SQL
SYSDATE

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.

CURRENT_DATE

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.
SYSTIMESTAMP

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.

#learningmonkey #dbms #placements #gatecse #gatedbms #campusplacements



Link for playlists:
   / @wisdomerscse  


Link for our website: https://learningmonkey.in

Follow us on Facebook @   / learningmonkey  

Follow us on Instagram @   / learningmonkey1  

Follow us on Twitter @   / _learningmonkey  

Mail us @ [email protected]