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-_
    ST_-Superman-_ πŸ”΅
    Accepted 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

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