ODBC/MX Driver for Windows Manual for SQL/MX Release 3.2.1 (H06.26+, J06.15+)
Table Of Contents
- HP NonStop ODBC/MX Driver for Windows
- Legal Notices
- Contents
- What’s New in This Manual
- About This Manual
- 1 ODBC/MX Client Overview
- 2 Installation of the ODBC/MX Client
- 3 Configuring Client Data Sources on Windows
- Accessing the Microsoft ODBC Data Source Administrator from a Client Workstation
- Adding New Client Data Sources
- Reconfiguring Client Data Sources
- Configuring Client Data Sources using Connection String
- Configuring Client Data Sources for Update Operations
- Configuring Driver for IPV6
- Removing Client Data Sources
- Tracing Client Data Sources
- 4 Module File Caching (MFC)
- 5 ODBC/MX Conformance
- ODBC API Functions
- SQL Conformance Level
- SQL Scalar Functions
- ODBC Data Types
- Unsigned Data Types
- Partial Date/Time Values
- SQL/MP Data Types and ODBC/MX Equivalents
- Microsoft Escape Clauses
- Stored Procedures
- Transactions and Cursor Behavior with Multiple Statements
- Timestamp Values with Fraction
- SQL Interval Insertion Property
- SQL Datetime Retrieval Property
- 6 ODBC/MX Messages
- Glossary
- Index
ODBC/MX Conformance
HP NonStop ODBC/MX Driver for Windows—691126-002
5-24
SQL Datetime Retrieval Property
SYSTEM_DEFAULT - Year is set to 0001.
MSDN_DEFAULT - Year is set to 1900.
If not specified, the default is SYSTEM_DEFAULT. This property is applicable only
when SQL/MP Datetime datatype is bound to SQL/MX datatypes such as DATE or
TIMESTAMP.
In the Data Access tab, set the SQL Datetime Retrieval property using the Microsoft
ODBC Data Source Administrator by selecting the respective Data Source
configuration.
Figure 5-2. Data source configuration for SQL Datetime Retrieval
If the value of SQL Datetime Retrieval is set to SYSTEM_DEFAULT, the behavior
of the driver is same as in earlier releases of SQL/MX.
For example:
Create a table in SQL/MP with Datetime column as “month to day”.
Insert the data “12–31” into the created table using SQL/MX or SQL/MP.