Multiple choice

You want to view the current time. Which of the following function(s) can be used to view the current time?

  1. TO_DATE

  2. DATE

  3. SYSDATE

  4. SYSTIME

  5. Not Possible

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

SYSDATE is an Oracle SQL function that returns the current date and time from the database server's operating system. TO_DATE converts string to date, DATE is a datatype not a function, and SYSTIME does not exist in Oracle. SYSDATE is the correct function to view current time.