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,

Don

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

Answers

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