Is there a way to convert a string to DateTime or equivalent to calculate difference in time for Amazon Redshift Data.

[Kevin Mai]

I am having trouble finding a way to use a function that converts a string "2019-09-08 13:13:38" to DateTime to find the difference with another similar string. The data does not let me choose a different data type, and I am limited to using functions within the Amazon Redshift documentation located in Spotfire. Anybody have a suggestion

[Shashank Gurnalkar]

Can you try to use a custom query and use the 'to_timestamp' function to convert the string columns into timestamp format as explained in the following redshift documentation

https://docs.aws.amazon.com/redshift/latest/dg/r_TO_TIMESTAMP.html

To know more about custom queries, refer to this:

https://docs.tibco.com/pub/sfire-analyst/10.3.3/doc/html/en-US/TIB_sfire-http://analyst_UsersGuide/connect/connect_what_are_custom_queries.htm