Differences between DATE and TIMESTAMP in Oracle
Q
What Are the Differences between DATE and TIMESTAMP in Oracle?
✍: FYIcenter.com
A
The main differences between DATE and TIMESTAMP 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.
⇒ Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle
⇐ Differences between NUMBER and BINARY_FLOAT in Oracle
2020-04-25, 5698🔥, 0💬
Related Topics:
