cherler opened a new issue #4098: About data_format problem such as '%%Y-%%m-%%d' in SQL editor and Visualize URL: https://github.com/apache/incubator-superset/issues/4098 Make sure these boxes are checked before submitting your issue - thank you! - [ ] I have checked the superset logs for python stacktraces and included it here as text if 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 ### Superset version { "GIT_SHA": "", "version": "0.20.6" } Hi: After select my table ,then i want to visualize the result,, but i got error result to show . I expect the x-axis is dates like 2015-03-20, 2015-03-28 in visualize web ; but i got x-axis is %Y-%m-%d . So i check the SQL sentence ,i found the diffrence between "sqllab query " and "visualize query" like below: sqllab query: `SELECT date AS date, sum(count) AS sum__count FROM (select DATE_FORMAT(FROM_UNIXTIME(tstamp-4500000000),'**%%Y-%%m-%%d**') as date, count(*) as count from loan_time group by date) AS expr_qry GROUP BY date ORDER BY sum__count DESC LIMIT 50000` visualize query: ` SELECT date AS date, sum(count) AS sum__count FROM (select DATE_FORMAT(FROM_UNIXTIME(tstamp-4500000000),'**%%%%Y-%%%%m-%%%%d**') as date, count(*) as count from loan_time group by date) AS expr_qry GROUP BY date ORDER BY sum__count DESC LIMIT 50000 ` PS: 1. The value of col 'tstamp' is like 5894316387 2. Cann't change sqllab query %%Y-%%m-%%d to %Y-%m-%d .because it will give me the error `unsupported format character 'Y' (0x59) at index 116`
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
