Time - PostgreSQL
The table below lists Magic xpa’s Time 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.
|
|
|
|
|
|
String Time
|
HH:MM:SS
|
6
|
CHAR
|
|
Integer Time
|
HH:MM:SS
|
4
|
INT
|
|
HMSH Time
|
HH:MM:SS
|
4
|
INT
|
|
Magic Time
|
HH:MM:SS
|
4
|
BYTEA
|
