SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Introduction
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
1-28
Selecting or Changing Data
For example, suppose that the location of the OBJECTS table is \nsk.$system.SQL.
To determine the physical name associated with a given logical SQL/MX object name,
you can query the OBJECTS table:
SELECT guardian_name
FROM \nsk.$system."SQL".objects
WHERE logical_name = 'samdbcat.persnl.employee';
In this example, "SQL" is written as a delimited identifier because SQL is a reserved
word in NonStop SQL/MX.
Selecting or Changing Data
To select or change SQL/MP data that does not directly map to SQL/MX data types
and literals, you can use special extensions of NonStop SQL/MX with some
restrictions.
DATETIME Data
The SQL/MP DATETIME data type is specified:
DATETIME [start-field TO] end-field
The start-field and end-field specify a range of logically contiguous fields:
YEAR
MONTH
DAY
HOUR
MINUTE
SECOND
FRACTION [(precision)]
The start-field must precede the end-field. The FRACTION field can include
the precision option only if the FRACTION field is the end-field.