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

[GitBox <gi...@apache.org>]

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: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org