Support Topics Documentation Slack YouTube Blog

Autogenerated table wrong data type

SWIFT SDK 6.0
When utilizing table autogenerating, the scheme created has wrong data types for the following

Date
Int

Both types are represented as Double

Trying to manually change it in the console has the following error

Updating column type failed. Changing column to type DATETIME will lead to loss of data.

The backend cannot always deduce the right type. Datetime values are sent by the client side as the number of milliseconds since epoch. As a result, to the backend it looks like a number (because it is a number), hence it will create the column as Int. In cases like these, it is recommended to create the schema either manually, or use the same API that the console uses to declare the columns.

Regards,
Mark