See the "floor" function (largest integer value not greater than argument)
in
http://sqlite.org/contrib/download/extension-functions.tgz?get=17
On 5/6/07, A.J.Millan <[EMAIL PROTECTED]> wrote:
Hi all:
I would like to know if there are a way to obtain a result without
decimals
(the integer part) in this query:
SELECT round(julianday('now')-Dat) FROM SomeTable WHERE ...;
Obviously Dat contain a Julian Date (nnn.nnn) and I want the difference in
days from today.
None the above, neither
SELECT round(julianday('now')-Dat, 0) FROM SomeTable WHERE ...;
Produces the desired result. I always get xxx.0 (1 decimal).
A.J.Millan
ZATOR Systems
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
