Workbench query changing column values

Options
DonAnderson
DonAnderson Member
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 ✓
    Options

    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 ✓
    Options

    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 Member
    Options

    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