You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "victortony (via GitHub)" <gi...@apache.org> on 2023/07/10 07:03:22 UTC
[GitHub] [superset] victortony opened a new issue, #24637: column formatting return wrong time
victortony opened a new issue, #24637:
URL: https://github.com/apache/superset/issues/24637
A clear and concise description of what the bug is.
#### How to reproduce the bug
1. click on "create chart"
2. choose "table" charttype
3. generate a query with time column
My time column called “partition_time” which format is "%Y%m%d%H"。The time filter get the right time formatting, but then query is returned, the result of time column is wrong formatting, which converted "2023071000" to "1970-01-24 09:57:51". The actual result is 2023071000, like the pic below:
<img width="244" alt="image" src="https://github.com/apache/superset/assets/13748044/c9a56f83-5364-45d2-8bb1-667c5a0569c7">
### Expected results
what you expected to happen.
### Actual results
what actually happens.
#### Screenshots
If applicable, add screenshots to help explain your problem.
### Environment
(please complete the following information):
- browser type and version:
- superset version: `2.0.1`
- python version: `3.8`
- node.js version: `v6.17.1`
- any feature flags active:
datasource: clickhouse
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [ ] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [ ] I have reproduced the issue with at least the latest released version of superset.
- [ ] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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.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
[GitHub] [superset] yousoph commented on issue #24637: column formatting return wrong time
Posted by "yousoph (via GitHub)" <gi...@apache.org>.
yousoph commented on issue #24637:
URL: https://github.com/apache/superset/issues/24637#issuecomment-1646178562
Hi @victortony !
The setting that you selected (Formatted Date and Original Date) is for the Results table at the bottom of the page.
If you'd like to format the time column in the table, use the Customize panel in Explore / Chart Builder, and select the date format in the Customize Columns section:
--
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
[GitHub] [superset] yousoph closed issue #24637: column formatting return wrong time
Posted by "yousoph (via GitHub)" <gi...@apache.org>.
yousoph closed issue #24637: column formatting return wrong time
URL: https://github.com/apache/superset/issues/24637
--
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