Workbench query changing column values

I've connected Workbench to my Postgresql DB and using a posgresql function. Workbench is incorrectly displaying the numeric column fields.

Postgresql returns as:

with the exact same query, domo workbench displays:

What is causing workbench to incorrectly display the values?

Thanks for the help,


Best Answer

  • ST_-Superman-_
    ST_-Superman-_ 🟀
    Answer βœ“

    It looks like this has something to do with the way each query engine is processing the time values. Would you mind sharing the syntax for those fields to get a sense of what is being calculated?

    β€œThere is a superhero in all of us, we just need the courage to put on the cape.” -Superman


  • DonAnderson
    DonAnderson βšͺ️

    Sort of. The time calculations weren't working as "I" expected. Once I figured that out, I was able to improve the query. Thank you for the response.