[GitHub] [superset] soitgoes511 edited a comment on issue #15768: Postgresql DB Engine Error: '>=' not supported between instances of 'datetime.timedelta' and 'int'

Sun, 25 Jul 2021 06:15:32 -0700 


soitgoes511 edited a comment on issue #15768:
URL: https://github.com/apache/superset/issues/15768#issuecomment-886179710


   After further experimentation, the issue seems to be timezones. If I removed 
the timezone offset with to_char(), my query works.
   
   **Update:**
   
   I was able to work around the issue with the following query:
   
   ```sql
   SELECT (time at time zone 'CEST')::timestamp without time zone AS "time",
          ma_spo2,
          ma_bpm,
          ma_perf
   FROM pulse_ox_moving_average
   ```
   
![superser_error_workaround](https://user-images.githubusercontent.com/22125622/126900290-2bd45d90-2389-44b2-9f59-2d12c0d9d197.png)
   
   This hack would allow me to create time-series charts where as using to_char 
would not. Setting a timezone and then localizing by removing the timezone is 
not ideal for the long term.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to