Last weekend there were errors on one of our production systems.
It seems that the problem can be traced back to this cause:
Error in "During" query for specific date/time - Invalid format
The bug appears to happen on any of the daylight savings time change start dates.
I tested with 03/12/2017, 03/13/2016, 03/08/2015, and 03/09/2014 and those fail at 2am. I also tested with the end of DST, but the bug didn't appear. Only the start of DST at 2am does the bug show.
The original post dates back to 2017.
Does anyone know if a solution has been found in these five years?
The only alternative would be to read all the issues avoiding the test of the data on the query and selecting the results through the application program but it is an inefficient solution.
Thank you for your attention.
