gsSQL
gsSQL copied to clipboard
dateDiff() works in morning, not in afternoon.
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())