Skip to content
Advertisement

About values(‘created_at__day’) and values(‘created_at__week’)

I wrote this code to sum up the daily and weekly counts with multiple data registered. What do the 2,3,18,22,27 in created_atday and 7,8,9,13 in created_atweek represent? Also, is there any way to make it easier to understand, such as 2021/3/5 for day and 2021/3/6- for week? I would appreciate it if you could tell me more about this.

JavaScript
JavaScript

in the case of created_at__day

JavaScript

in the case of created_at__week

JavaScript

Advertisement

Answer

day is the integer value between 1 and 31 (including 31) which represent the day of the month

week is the integer value between 1 and 52 (including 52) which represent the week number

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement