Date Datatypes in oracle

By Santhosh N

There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable

The four datatypes in oracle to store date times are

1) DATE Datatype
2) TIMESTAMP Datatype
3) TIMESTAMP WITH TIME ZONE Datatype
4) TIMESTAMP WITH LOCAL TIME ZONE Datatype

Related FAQs

Listing all tables in Oracle depends on the user logged in and the schema one logs in
Date Datatypes in oracle  (983 Views)