Workbench query changing column values

DonAnderson · 2021-02-15T18:22:21+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

ST_Superman

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?

All comments

ST_Superman

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

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of