Can someone please explain these inconsistent resu...
# questions-and-troubleshooting
g
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