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
On 1/31/07, T <[EMAIL PROTECTED]> wrote:
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
--
--
The PixAddixImage Collector suite:
http://groups-beta.google.com/group/pixaddix
SqliteImporter and
From: "T" <[EMAIL PROTECTED]>
Hi Jeff,
I've encountered some functions that apparently aren't supported by
SQLite
So have I, such as replacing occurrences of an inner string.
so I've created my own
I've yet to figure out/try that. Is there a library somewhere of
prebuilt functions we
Hi Jeff,
I've encountered some functions that apparently aren't supported by
SQLite
So have I, such as replacing occurrences of an inner string.
so I've created my own
I've yet to figure out/try that. Is there a library somewhere of
prebuilt functions we can add? Is there and mechanism
From: <[EMAIL PROTECTED]>
I'm not sure what "int()" does. Maybe you are looking for round().
Or perhaps cast(expr AS int) will serve your needs.
Sorry, I should have been clearer. INT just forces the result to be
an integer. So, your "cast" example is probably what I need.
Thanks for
"Jeff Godfrey" <[EMAIL PROTECTED]> wrote:
> I'm currently converting some Access tables/views to SQLite.
> I've encountered some functions that apparently aren't
> supported by SQLite, so I've created my own (a power function
> and an "IIF" function). Also, several of my queries have a
> basic
I'm currently converting some Access tables/views to SQLite. I've encountered
some functions that apparently aren't supported by SQLite, so I've created my
own (a power function and an "IIF" function). Also, several of my queries have
a basic int() wrapper, that also seems to be unsupported.
7 matches
Mail list logo