Multiple choice technology databases

Which function will take input parameter...?

  1. tz_offse

  2. sessiontimezone

  3. systemstamp

  4. sysdate
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TZ_OFFSET is an Oracle function that takes a time zone region name or abbreviation as input and returns the offset from UTC. For example, TZ_OFFSET('US/Eastern') returns the timezone offset. SESSIONTIMEZONE and SYSDATE don't take input parameters, and SYSTEMSTAMP isn't a valid function.

Keep practicing — related questions