Comment on page
Sometimes the system cannot identify data types correctly due to data impurities. Another situation is that some functions or formulas are limited for certain data types. For example, the
concate()function in Formula can only be used for the
Change Typeallows you to manually change the data type of any column to the desired type. For example, change a string field to numeric, or date to strings.
When changing a
Stringcolumn to the date and time types, you have to be careful that if values are in a standard expression of the specific date and time type. Otherwise, the system will run in an error.
Dateonly accepts a string format of
yyyy-mm-dd, such as "2016-12-25".
Datetimeonly accepts a string format of
yyyy-mm-dd hh:mm:ss, such as"2020-12-01 14:20:32".
Timestamponly accepts a string format of
yyyy-mm-dd hh:mm:ss timezone, such as "2020-12-25 15:30:00 UTC".
Timeonly accepts a string format of
hh:mm:ss, such as "23:30:00"