Basic Oracle Concepts and Programming Question: Download Questions PDF
What Are the Differences between DATE and TIMESTAMP in Oracle?
Answer:
The main differences between DATE and TIMESTAMP in Oracle are:
* DATE stores values as century, year, month, date, hour, minute, and second.
* TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.
* DATE stores values as century, year, month, date, hour, minute, and second.
* TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.
Download Oracle Database Interview Questions And Answers
PDF
Previous Question | Next Question |
What Are the Differences between NUMBER and BINARY_FLOAT in Oracle? | What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND? |