Exercise

Current timestamp functions

Use the console to explore the NOW(), CURRENT_TIMESTAMP, CURRENT_DATE and CURRENT_TIME functions and their outputs to determine which of the following is NOT correct?

Instructions

50 XP

Possible Answers

NOW() returns the current date and time as a timestamp with timezone.
CURRENT_TIMESTAMP returns the current timestamp without timezone.
CURRENT_DATE returns the current date value without a time value.
CURRENT_TIME returns the current time value without a date value.

Take Hint (-15 XP)