Grouping Millis by Date and Hour
Posted: Wed Aug 23, 2017 3:55 pm
Hey all!
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
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