You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2018/06/15 15:07:52 UTC
[GitHub] EvelynTurner opened a new pull request #5211: Evelynturner/prestofix
EvelynTurner opened a new pull request #5211: Evelynturner/prestofix
URL: https://github.com/apache/incubator-superset/pull/5211
Context:
```
presto> SELECT CAST(from_unixtime((1528761599980/1000.0)) AS TIMESTAMP);
-------------------------
2018-06-12 00:00:00.000
presto> SELECT CAST(from_unixtime((1528761599980/1000)) AS TIMESTAMP);
-------------------------
2018-06-11 23:59:59.000
presto> SELECT CAST(from_unixtime((1528761599980/1000.00)) AS TIMESTAMP);
-------------------------
2018-06-11 23:59:59.980
```
In an unfortunate event where the entry is < 1 second from the next day, the generated query casts it to the next day. This shouldn't be a problem in MySQL, but it is in Presto.
<img width="1023" alt="screen shot 2018-06-14 at 1 54 36 pm" src="https://user-images.githubusercontent.com/36863942/41475269-4f07df2e-708c-11e8-8b01-dc5a1cf99168.png">
----------------------------------------------------------------
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:
users@infra.apache.org
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org