HP Driver for JDBC User's Manual

Appendix A 63
Data Types
ALLBASE/SQL Data Types
DATETIME String of characters in the format
“YYYY-MM-DD HH:MI:SS.FFF” where
YYYY represents the calendar year, MM
is the month, DD is the day of the
month, HH is the hour, MI is the minute,
SS is the second, and FFF is the
thousandth of a second. DATETIME is in
the range
“0000-01-01 00:00:00.000” to
“9999-12-31 23:59:59.999”.
INTERVAL String of characters in the format
“DDDDDDD HH:MI:SS.FFF” where
DDDDDDD is a number of days, HH is a
number of hours, MI is a number of
minutes, SS is a number of seconds,
and FFF is a number of milliseconds.
INTERVAL is in the range
“0 00:00:00.000” to
“3652436 23:59:59.999”.
BINARY Binary string of fixed-length n where n
is in the range of 1 to 3996 bytes. Each
byte stores 2 hexadecimal digits.
VARBINARY Binary string of variable-length up to
length n where n is in the range of 1 to
3996 bytes. Each byte stores
2 hexadecimal digits.
LONG BINARY Binary string of fixed-length up to
length n where n is in the range of 1 to
(2
31
-1) bytes. This data type is
currently not supported by the HP
Driver for JDBC.
LONG VARBINARY Binary string of variable-length up to
length n where n is in the range of 1 to
(2
31
-1) bytes. This data type is
currently not supported by the
HP Driver for JDBC.