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)