#sqlreporti — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqlreporti, aggregated by home.social.
-
What's wrong with this SQL time zone filter?
What's wrong with this SQL time zone filter in reporting. The SQL code compares a local time to UTC stored timestamps, so boundaries shift by hours. In SQL analytics this miscounts events.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqltimezonebug #sqldatetime #sqlreporti...
-
What's wrong with this SQL time zone filter?
What's wrong with this SQL time zone filter in reporting. The SQL code compares a local time to UTC stored timestamps, so boundaries shift by hours. In SQL analytics this miscounts events.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqltimezonebug #sqldatetime #sqlreporti...