Date

DATE

ORACLE and ALTIBASE HDB are alike in using DATE data type.

But there is a little bit difference between ORACLE and ALTIBASE HDB.

The smallest unit of DATE type in ALTIBASE HDB is microsecond (1/1000000 second) but that in ORACLE is millisecond(1/10000).

Except time precision in DATE data type, it is same as ORACLE including DATE type conversion functions. (TO_CHAR / TO_DATE)

A timestamp data type in ALTIBASE HDB is totally different with ORACLE's timestamp data type.

There is no data type corresponding to the ORACLE timestamp data type in ALTIBASE HDB.

Even though a timestamp data type in ORACLE may be converted to date data type in ALTIBASE HDB, it can cause data loss between them in conversion.

Using a timestamp data type in ORACLE, maximum allowable value ran to nanosecond.

Whereas, in case of ALTIBASE HDB, it can express up to microsecond.

A timestamp data type does exist in ALTIBASE HDB.

Unlike a timestamp data type in ORACLE, it only stores system time value.

ALTIBASE HDB does not support this type.

ALTIBASE HDB does not support this type.