Links
Comment on page

Change Type

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 String columns. Change Type allows 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.

Troubleshooting

When changing a String column 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.
  • Date only accepts a string format of yyyy-mm-dd, such as "2016-12-25".
  • Datetime only accepts a string format of yyyy-mm-dd hh:mm:ss, such as"2020-12-01 14:20:32".
  • Timestamp only accepts a string format of yyyy-mm-dd hh:mm:ss timezone, such as "2020-12-25 15:30:00 UTC".
  • Time only accepts a string format of hh:mm:ss, such as "23:30:00"
If your data has a different expression but you want to change it into a date and time type, you can try PARSE_DATE(), PARSE_DATETIME(), PARSE_TIMESTAMP(), or PARSE_TIME() in Formula.
Last modified 2yr ago