Salesforce

Date - MySQL (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Date - MySQL (Magic xpa 4.x)

The table below lists Magic xpa’s Date attribute and the valid data types for MySQL. 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

MySQL
Data
Type

String Date

##/##/####

8

SQL_DATE

Integer Date

##/##/####

4

SQL_INTEGER

Integer Date 1901

##/##/####

4

SQL_INTEGER

YYMMDD Date

##/##/####

4

SQL_BINARY

Magic Date

##/##/####

4

SQL_BINARY

Magic Date 1901

##/##/####

4

SQL_BINARY

Reference
Attachment 
Attachment