Was hoping you guys could help me out.
I'm currently trying to group a millis column into Date and Hour.
For Example, the column is
Times
1484261834099
1484337025118
1484352178132
1484367983155
1484523555099
1484550424125
1484793955197
1484825845127
1485074682136
1485753969092
I'd like it to be:
2017-08-01 12:00
2017-08-01 13:00
2017-08-01 14:00
etc with multiple dates. I've tried DATE_PART, but can't work it out!
Thanks
![Smile :)](./images/smilies/icon_e_smile.gif)