Q129 Which two statements are true about time zones, date data types, and timestamp data type in an Oracle database?
- A) The CURRENT_TIMESTAMP function returns data without time zone information
- B) A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row
- C) The DATE datatype returns data with time zone information
- D) The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
- E) The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)
Answer: D,E
Explanation:
• TIMESTAMP WITH LOCAL TIME ZONE is another variant of TIMESTAMP. It differs from TIMESTAMP WITH TIME ZONE as follows: data stored in the database is normalized to the database time zone, and the time zone offset is not stored as part of the column data. When users retrieve the data, Oracle Database returns it in the users’ local session time zone. The time zone offset is the difference (in hours and minutes) between local time and UTC (Coordinated Universal Time, formerly Greenwich Mean Time).
SQL> select CURRENT_TIMESTAMP, DBTIMEZONE, SESSIONTIMEZONE from dual;