Which datatype is used to stored time zone information in Oracle?
By Santhosh N
Oracle provides a seperate datetype for storing time zone information in the column
TIMESTAMP WITH TIME ZONE is used to store the time zone region or time zone offset value in the oracle table column
EG: '2025-10-31 07:33:00 US/Pacific PDT'
'2025-10-05 11:38:00 -5:00'
Related FAQs
There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable
Which datatype is used to stored time zone information in Oracle? (753 Views)