MX 2.x)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

DATETIME YEAR TO MINUTE

DATETIME MONTH

DATETIME MONTH TO DAY

DATETIME MONTH TO HOUR

DATETIME MONTH TO SECOND

DATETIME DAY

DATETIME DAY TO HOUR

DATETIME DAY TO MINUTE

DATETIME DAY TO SECOND

DATETIME HOUR

DATETIME HOUR TO MINUTE

DATETIME MINUTE

DATETIME MINUTE TO SECOND

DATETIME SECOND

DATETIME FRACTION

INTERVAL YEAR(p)

INTERVAL YEAR(p) TO MONTH

INTERVAL MONTH(p)

INTERVAL DAY(p)

INTERVAL DAY(p) TO HOUR

INTERVAL DAY(p) TO MINUTE

INTERVAL DAY(p) TO SECOND

INTERVAL HOUR(p)

INTERVAL HOUR(p) TO MINUTE

INTERVAL HOUR(p) TO SECOND

INTERVAL MINUTE(p)

INTERVAL MINUTE(p) TO SECOND

INTERVAL SECOND(p)

Floating-Point Support

The JDBC/MX driver and the NonStop Server for Java pass any FLOAT (32-bit) number or DOUBLE (64-bit)

number in the IEEE 754 floating-point format.

Floating-point values are stored in SQL/MX tables as IEEE 754 values.

Floating-point values are stored in SQL/MP tables in Tandem format (called TNS format in OSS terminology. For

floating-point values stored in SQL/MP tables in the Tandem format, SQL/MX performs the conversion from the IEEE

754 format to the Tandem format when storing the values and from the Tandem format to the IEEE 754 format when

retrieving and passing the values.

Since SQL/MX tables store IEEE 754 floating-point values, JDBC applications accessing floating-point data do not

receive floating-point exceptions. The JDBC applications should check for plus (+) or minus (-) infinity conditions to

determine if an overflow or underflow has occurred. Applications can also encounter a not-a-number value being

passed back, for example, for numbers divided by zero. This processing is done according to the IEEE 754 standard.

SQL/MP tables can generate floating-point exceptions.

For the range of floating-point values and double-precision values for IEEE 754 format and TNS format, see the

NonStop Server for Java Programmer's Reference. For information on floating-point formats in SQL/MX, see "Data

Types" in the SQL/MX Reference Manual.

SQL Escape Clauses

JDBC/MX accepts SQL escape clauses and translates them into equivalent SQL/MX clauses, as shown in the

following table:

SQL Escape Clause SQL/MX Equivalent Clause

{ d 'date-literal' } DATE 'date-literal'