Kevin Mai Posted May 8, 2020 Share Posted May 8, 2020 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 Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted May 10, 2020 Share Posted May 10, 2020 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now