diff options
Diffstat (limited to 'models/user_heatmap.go')
| -rw-r--r-- | models/user_heatmap.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/models/user_heatmap.go b/models/user_heatmap.go index 9e603f4fe1..0745a66058 100644 --- a/models/user_heatmap.go +++ b/models/user_heatmap.go @@ -28,7 +28,7 @@ func GetUserHeatmapDataByUser(user *User) ([]*UserHeatmapData, error) { case setting.UsePostgreSQL: groupBy = "extract(epoch from date_trunc('day', to_timestamp(created_unix)))" case setting.UseMSSQL: - groupBy = "dateadd(DAY,0, datediff(day,0, dateadd(s, created_unix, '19700101')))" + groupBy = "datediff(SECOND, '19700101', dateadd(DAY, 0, datediff(day, 0, dateadd(s, created_unix, '19700101'))))" groupByName = groupBy } |