Jump to content

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

Kevin Mai

Recommended Posts

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

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


To know more about custom queries, refer to this:


Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...