Can someone please explain these inconsistent results for timediff?
SELECT *timediff*("2025-07-01 030000","2025-07-01 040000");
-- = -010000 -- NEGATIVE 1 Hour So B-A (date_sub)= -1 Hour, not the ABS of difference
SELECT *timediff*("2025-07-01 032900","2025-07-01 040000");
-- = 003100 -- POSITIVE 31 min is the actual difference in time, not B-A