Which of the following datatypes store time-zone information in the database?
A. TIMESTAMP
B. DATE
C. TIMESTAMP WITH TIME ZONE
D. TIMESTAMP WITH LOCAL TIME ZONE
E. DATETIME
Only the TIMESTAMP WITH TIME ZONE datatype actually stores time-zone information in the database.The TIMESTAMP WITH LOCAL TIME ZONE datatype converts the timestamp to local time and drops the time-zone information before storing it in the database.DATE and TIMESTAMP datatypes do not deal with time-zone information at all.DATETIME is not a valid datatype.