alfredho811 commented on issue #21508: URL: https://github.com/apache/superset/issues/21508#issuecomment-1250972549
Hey @mdeshmu Thanks for your reply. I guess I did not phrase my problem correcty.  As you can see from the above screenshot, the problem is that the column `date_trunc('month', release_time_hkt)` becomes `unix timestamp`. Instead, I want it to be like `2022-08-01`, `2022-09-01` instead. ============= For the column `release_time_hkt`, I notice that Superset marked it as `TIMESTAMP WITHOUT TIME ZONE`  ========== **Similar problem** Given that I am using Postgres as my database and the problematic column is of type `date` in postgres, I find that the below issue is quite similar to mine. - Link: https://github.com/apache/superset/issues/13295 The solution here is to format the datetime as string https://github.com/apache/superset/issues/13295#issuecomment-783986140 Is that the only solution? Thanks -- 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]
