Time - MySQL (Magic xpa 2.x)
The following table lists Magic xpa’s Time 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 Time
|
HH:MM:SS
|
6
|
SQL_TIME
|
|
Integer Time
|
HH:MM:SS
|
4
|
SQL_INTEGER
|
|
HMSH Time
|
HH:MM:SS
|
4
|
SQL_BINARY
|
|
Magic Time
|
HH:MM:SS
|
4
|
SQL_BINARY
|
