Group by and FROM_UNIXTIME function

Hello, Firstly, the FROM_UNIXTIME function's date pattern is case sensitive : * FROM_UNIXTIME(1451308548, '-MM') --> 2015-12 * FROM_UNIXTIME(1451308548, '-MM') --> 2016-12 (because is not a valid date pattern and 2016 is the current year) Consider the following que

TR: Group by and FROM_UNIXTIME function

Hello, Firstly, the FROM_UNIXTIME function's date pattern is case sensitive : * FROM_UNIXTIME(1451308548, '-MM') --> 2015-12 * FROM_UNIXTIME(1451308548, '-MM') --> 2016-12 (because is not a valid date pattern and 2016 is the current year) Consider the following que