Why does this SQL partition skip data?

Why does this SQL partition skip data in reporting. The SQL query filters on a partition boundary with the wrong timezone, so rows land in the wrong partition. In SQL analytics this miscounts totals.

#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlpartition #sqltimezonebug #sqlr...

https://www.youtube.com/watch?v=8Yw6CZspyrM

Howdy folks, my name is Dane, and this is my podcast. We play #DnD and #Starfinder in a gloriously silly fashion. We're a found family that that support and love each other (even Lando), so if you give a listen to the below and enjoy, visit us at our link tree at http://linktr.ee/sqlr and check us out. #sqlr #ttrpgs

Never underestimate the power of a smile.
-Moot