2 Replies Latest reply on Oct 13, 2016 1:05 AM by Angelo Canepa

    Data Type Formatting in PostgreSQL and Tableau

    Angelo Canepa

      Hello,

       

      I having a problem with Postgres and time data type.

      I'm working with Tableau and I'm trying to convert the column called start_at_minute, where it says the hours that a particular schedule start to run, the problems that this column is in minutes so for example if the schedule starts at 8:15 there is 495 minutes.

       

      I have the next formula

      cast(to_timestamp(concat((start_at_minute/60),':',(cast(start_at_minute as float)/60-(start_at_minute/60))*60),'HH24 MI') as TIME) as scheduletime

       

      But the problem is that Tableau after executing the query launches an error, 'Unrecognised Error'

       

      PS: I'm using Tableau 9.0

       

      Regards,