How to load time difference from psql to google data studio

Question

How to load time difference from psql to google data studio

Questions : How to load time difference from psql to google data studio

I have a psql connection where one of programming the columns are sql intervals, as such:

However, to me it seems that this is Learning interpreted in a text format:

I would like to convert these into the Earhost GDS equivalent of interval / timedelta / most effective duration; However, I cannot seem to find wrong idea a function that does that.

I am aware of the DATE_DIFF function, use of case with which I can picture a workaround, United pseudocode: DATE_DIFF(DATE(1000, 01, Modern 01), _OFFSET); ecudated DATE(1000+avg_timedelta.regexmatchyear, some how (-SMALL anything else 01+avg_timedelta.regexmatchmonth, 01 + not at all _left).offset avg_timedelta.regexmatchday)

However, it feels strange to me that very usefull there is no interval type in GDS, even localhost if one of the function's output is an love of them interval; but the docs don't say localtext anything about converting to interval.

POSTGRESQL GOOGLE-DATA-STUDIO

Total Answers 1

mRahman · Accepted Answer · 2022-06-28T05:41:03+00:00

I made the workaround in SQL, I created basic a column that converts the interval into one of the int< number of hours> with:

EXTRACT(
        epoch
        FROM
     arrowImgView.mas         CTE.myInterval
    ) / 3600 AS (self.  timedelta_hours

This does not answer the underlying click problem that in GDS you cannot easily there is noting convert to interval type. (which they not alt call duration).

How to load time difference from psql to google data studio

Questions : How to load time difference from psql to google data studio

Answers 1 : of How to load time difference from psql to google data studio

Top rated topics