Functional restrictions specific to PostgreSQL adapter

If you enter a six-digit integer that is interpretable as time in one of the following data types, it may be inserted as time during the insert operation by the PostgreSQL adapter:

• TIME

• TIME WITH TIMEZONE

Additionally, if you insert a floating point number that is interpretable as time composed of a six-digit integer and a decimal of zero to six digits, it may be inserted as time.

Time is interpreted according to PostgreSQL specifications.

Examples:

• If you enter the integer "123456", it is interpreted as "12:34:56" and processed as time.

• If you enter the integer "240000", it is interpreted as "00:00:00", and processed as time.

• If you enter the integer "240001", it is not interpreted as time, and an error occurs.

• If you enter the floating point number "123456.123456", it is interpreted as "12:34:56.123456" and processed as time.

• If you enter the floating point number "123456.1234567", the digits after the seventh decimal place are rounded, thus the number is interpreted as "123456.123457" and processed as time.