When selecting a dataset from an SQL query, a typing error occurred: date values including a timezone are not recognized as such.
Solution:
When writing the SQL query in ToD, it is possible to use the function CAST( <value:expression> AS <SQL type:text> ) to convert a value to an ANSI SQL type. This is to normalize dates so they do not include a timezone.
How to normalize timestamp and timezone errors?
When selecting a dataset from an SQL query, a typing error occurred: date values including a timezone are not recognized as such.
Solution:
When writing the SQL query in ToD, it is possible to use the function CAST( <value:expression> AS <SQL type:text> ) to convert a value to an ANSI SQL type. This is to normalize dates so they do not include a timezone.