So when Appian writes dates to Json, it cannot cast those values correctly if it reads them back. ... recommended methodology is for retrieving the datetime value when the date data type itself is used in the JSON string. ... tointeger(today())
cannot-cast-type-json-to-integer
Casts the arg parameter to a number using the following casting rules ... a value that cannot be represented as a JSON number (e.g. Infinity, complex numbers).. Spark SQL expression provides data type functions for casting and we can't use cast() function. Below INT(string column name) is used to convert to Integer Type. 3925e8d270
cannot cast type json to integer, postgres cannot cast type json to integer, postgresql error cannot cast type json to integer, postgres error cannot cast type json to integer, cannot cast type json to integer postgres