[sqlite] How to obtain the integer part of a result

[A.J.Millan]

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]
-----------------------------------------------------------------------------