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. 
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 ofyyyy-mm-dd
, such as "2016-12-25".Datetime
only accepts a string format ofyyyy-mm-dd hh:mm:ss
, such as"2020-12-01 14:20:32".Timestamp
only accepts a string format ofyyyy-mm-dd hh:mm:ss timezone
, such as "2020-12-25 15:30:00 UTC".Time
only accepts a string format ofhh: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