Date - ODBC (Magic xpa 2.x)
The table below lists Magic xpa’s Date attribute and the valid data types for ODBC. Each entry in the table has a default data type that can be forced by specifying that type in the Type property on the SQL section in the Column Properties sheet.
|
Magic xpa
Storage
Type
|
Magic xpa
Picture
|
Magic xpa
Storage
Size
|
ODBC Data
Type
|
|
String Date
|
##/##/####
|
8
|
SQL_CHAR
|
|
Integer Date
|
##/##/####
|
4
|
INTEGER
|
|
Integer Date 1901
|
##/##/####
|
4
|
INTEGER
|
|
YYMMDD Date
|
##/##/####
|
4
|
BINARY
|
|
Magic Date
|
##/##/####
|
4
|
BINARY
|
|
Magic Date 1901
|
##/##/####
|
4
|
BINARY
|
|
Note:
|
If you want to map String Date to ODBC Character, specify ‘SQL_CHAR(8)’ as the Type under the column properties/SQL.
|
