Oracle 日期和时间戳的区别

Oracle DATE 和 TIMESTAMP 类型有什么区别？ 都有日期和时间成分吗？ 对于这些日期类型，Java 中的对应类型是什么？

115642 次浏览
小开
最佳答案

DATE and TIMESTAMP have the same size (7 bytes). Those bytes are used to store century, decade, year, month, day, hour, minute and seconds. But TIMESTAMP allows to store additional info such as fractional seconds (11 bytes) and fractional seconds with timezone (13 bytes).

TIMESTAMP was added as an ANSI compliant to Oracle. Before that, it had DATE only.

In general cases you should use DATE. But if precision in time is a requirement, use TIMESTAMP.

And about Java, the oracle.sql.DATE class from Oracle JDBC driver, provides conversions between the Oracle Date/Timestamp data type and Java classes java.sql.Date, java.sql.Time and java.sql.Timestamp.

小开

Illustration of datetime data types in Oracle: enter image description here

and supporting functions: enter image description here


提交答案