gsSQL icon indicating copy to clipboard operation
gsSQL copied to clipboard

dateDiff() works in morning, not in afternoon.

Open demmings opened this issue 2 years ago • 0 comments

In order for my tests to always work, I added this as a test for dateDiff() so that it would always return '7'. There is something wrong with the ROUNDING. I call FLOOR, but it appears to be rounding up. Anyway, not sure at this point.

The only weird thing is that the tests always seems to work when run in Google Sheets. It just appears to only fail in NODE.JS. Anyway, it causes my tests to sometimes fail.

datediff(adddate(curDate(),7), now())

demmings avatar May 08 '23 16:05 demmings