PHD Discussions Logo

Ask, Learn and Accelerate in your PhD Research

Question Icon Post Your Answer

Question Icon

7 years ago in Data collection By Yashti Iyer

Temporal data types in oracle

Can someone explain temporal data types in oracle? It would be of great help guys

All Answers (3 Answers In All)

By Karan D Answered 7 years ago

Date Data Type : This type consists dates of different formats
TimeStamp Data Type: This type of data type consists timestamp of different format
Interval Data Type: Here we have interval between time and date

By Kamlesh Meena Answered 7 years ago

There are 3 types of temporal data types in oracle. Date data type, timestamp data type and interval data type.
The Date data type holds not just date but also time information. Oracle stores dates internally regardless of the date format that is displayed.
Timestamp data types provides support for fractional seconds along with date and time data.It also provides support for time zones.

By Meghana R Answered 7 years ago

Visit http://etutorials.org/SQL/Mastering+Oracle+SQL/Chapter+6.+Handling+Temporal+Data/6.2+Temporal+Data+Types+in+Oracle/

Your Answer