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-_
    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


  • 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.