System Functions

 

USER Function

              Returns the current username. Returns the database user executing the query.

              SELECT USER FROM dual;

              Output

USER
HR

SYSDATE:

              Returns the current system date and time.

              SELECT SYSDATE FROM dual;

Output

SYSDATE
05-MAR-2025

              Returns the current date from the server.

 

SYSTIMESTAMP Function

              Returns the current timestamp with timezone.

              SELECT SYSTIMESTAMP FROM dual;

              Output:

SYSTIMESTAMP
05-MAR-2025 10:15:30.123456 AM +05:30