ODBC/MX Driver for Windows Manual (SQL/MX 2.x)

ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—527888-004
5-13
Microsoft Escape Clauses
Microsoft Escape Clauses
ODBC/MX accepts Microsoft escape clauses and translates them into equivalent
SQL/MX clauses.
DATETIME DAY SQL_DATE
DATETIME DAY TO HOUR SQL_TIMESTAMP
DATETIME DAY TO MINUTE SQL_TIMESTAMP
DATETIME DAY TO SECOND SQL_TIMESTAMP
DATETIME DAY TO FRACTION SQL_TIMESTAMP
DATETIME HOUR SQL_TIME
DATETIME HOUR TO MINUTE SQL_TIME
DATETIME HOUR TO SECOND SQL_TIME
DATETIME HOUR TO FRACTION SQL_TIMESTAMP
DATETIME MINUTE SQL_TIME
DATETIME MINUTE TO SECOND SQL_TIME
DATETIME MINUTE TO FRACTION SQL_TIMESTAMP
DATETIME SECOND SQL_TIME
DATETIME SECOND TO FRACTION SQL_TIMESTAMP
Table 5-18. Microsoft Escape Clauses
Microsoft Escape Clause SQL/MX Equivalent
{ d 'date-literal' } DATE 'date-literal'
{ t 'time-literal' } TIME 'time-literal'
{ ts 'timestamp-literal' } TIMESTAMP 'timestamp-literal'
1
{ oj join-expression } join-expression
{ INTERVAL sign
interval-string
interval-qualifier }
INTERVAL sign
interval-string
interval-qualifier
{ fn scalar-function } scalar-function
2
{ call
procedure-name... }
Supported in current release
Table 5-17. SQL/MP to ODBC/MX Date/Time Mappings
SQL/MP Data Type ODBC/MX Data Type Returned