zhengyangfeng00 commented on issue #22390:
URL: https://github.com/apache/superset/issues/22390#issuecomment-1556478580
for anyone looking for a temp workaround, here is what I do while waiting
for a fix:
``` sql
CREATE OR REPLACE VIEW temp AS
SELECT
name,
toDateTime(`timestamp` + 28800) as ts,
toDate(`ts`) as date
FROM X
```
the code above applies the offset 28800 (UTC+8) to the unix timestamp
directly
--
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]
