Multiple choice technology databases

AST,GMT,XST..... can be used as parameters for which function..?

  1. next_day()

  2. add_months()

  3. new_time()

  4. old_year()
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

NEW_TIME is an Oracle function that converts a date from one time zone to another. It takes three parameters: the date, the source timezone (like AST, GMT, etc.), and the target timezone. For example, NEW_TIME(SYSDATE, 'GMT', 'EST') converts from GMT to EST.

Keep practicing — related questions