Workbench query changing column values

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 Domo Employee
    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?

Answers

  • ST_Superman
    ST_Superman Domo Employee
    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?

  • DonAnderson
    DonAnderson Member

    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