Premium lockedData QualityIntermediate
UTC to Local Timezone Boundary Broke Daily Dashboard
The report groups by the UTC calendar date. Orders between 18:30 and 23:59 UTC belong to the next calendar day in Asia/Kolkata, so the dashboard shifts late-night revenue into the wrong business date.
Practice type
Broken SQL Fix
Estimated time
19 min
Skills
SQL, Timezone, Reporting
Create an account to continue
Sign in with OTP first, then choose a plan and complete UPI activation.