Workbench query changing column values

DonAnderson
DonAnderson
in Workbench

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

Postgresql returns as:

image.png


with the exact same query, domo workbench displays:

image.png


What is causing workbench to incorrectly display the values?


Thanks for the help,

Don

Best Answer

  • ST_-Superman-_
    ST_-Superman-_ Coach
    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-_
    ST_-Superman-_ Coach
    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.

Categories