Hi Jay,
or better yet, I expected this to work, using the modulo operator %:
SELECT x - x % 1;
Isn't that evaluated left to right?
x-x = 0
0 %1 = 0
I don't think so. Well, yes, it is generally evaluated left to right,
but mod has precedence of minus, so it gets evaluated first. So even
putting in brackets we get the same answer:
sqlite> select 3.44 - (3.44 % 1);
3.44
sqlite> select 3.44 - 3.44 % 1;
3.44
Tom
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
