Salesforce

Date - PostgreSQL (Magic xpa 4.x)

Printable View
« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

Date - PostgreSQL

The table below lists Magic xpa’s Date attribute with the valid PostgreSQL data types.

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

PostgreSQL Data Type

String Date

##/##/####

8

TIMESTAMP

Integer Date

##/##/####

4

INT

Integer Date 1901

##/##/####

4

INT

YYMMDD Date

##/##/####

4

BYTEA

Magic Date

##/##/####

4

BYTEA

Magic Date 1901

##/##/####

4

BYTEA

Reference
Attachment 
Attachment