Post Your Answer
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
TimeStamp Data Type: This type of data type consists timestamp of different format
Interval Data Type: Here we have interval between time and date
Reply to Karan D
By Kamlesh Meena Answered 7 years ago
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.
Reply to Kamlesh Meena
By Meghana R Answered 7 years ago
Reply to Meghana R
Related Questions