Pitney Bowes MapXtreme User Manual
Page 156
Chapter 8: Working with Data
Catalog and Tables
MapXtreme v7.1
163
Developer Guide
Time and DateTime Data Source Support
MapXtreme can read Date, DateTime, and Time data (and save it back if applied) on the supported
data sources and data providers. The different data sources may have different type definitions on
date/time, which may or may not match MapXtreme types exactly.
The new data types are supported for the following data sources:
•
Mem tables
•
Native tables (TAB files)
•
ADO.NET
•
Oracle via OCI
•
MS SQL Server via ODBC
The ASCII and dBase, and Microsoft Access data sources are not supported.
Date and DateTime Support in Remote Databases
Remote databases may not support all the data types that MapXtreme supports. The table below
shows the date and time-based types supported in native TAB files and in each supported database.
Grid
A GridInfo from table's grid column. This is the data type of the GridInfo object
stored in grid column on a Table.
Wms
Provides a WmsClient from the table's Wms column. This is the data type of
the WmsClient object stored in the Wms column on a Table.
*
To ensure backward compatibility with earlier versions of MapXtreme, the
MapInfo.Data.MIDataReader.GetDateTime method works with both the DateTime and Date types. In
both cases, a System.DateTime value is returned. However, the MapInfo.Data.Column.DataType will
reflect the actual data type, either Date or DateTime.
†
The Time and DateTime types are not supported for MapInfo SQL functions. However, in MapInfo
SQL functions that call/use a DateTime type, the function will return the date portion of the DateTime
value. Please see the MapInfo SQL Reference for more information.
‡
The Time and DateTime types are not supported for MapInfo SQL functions. However, in MapInfo
SQL functions that call/use a DateTime type, the function will return the date portion of the DateTime
value. Please see the MapInfo SQL Reference for more information.
Data Type
Description
MapXtreme
Native TAB
Files
ADO.NET
Oracle (OCI)
MS SQL
Server
Date
Date Date
Time
Time
DateTime
DateTime
DateTime
DateTime
DateTime