On Mon, Mar 7, 2011 at 7:46 AM, Stephen De Gabrielle <
[email protected]> wrote:
> Hi,
>
> My SQL query statement against the "TICKET" table includes a line crafted
> to return the number of whole days till the 'last useful date'
> round(julianday(last_useful_date) - julianday('now'),0) AS 'days left',
>
> Problem is, it returns '.0' when [I believe] I specified zero decimal
> places as the second argument of the 'round()' function.
>
> What am I doing wrong?
>
The round() function always returns a floating point number. Try using
"CAST(<expr> AS INTEGER)" instead.
>
> Cheers,
>
> Stephen
>
>
> --
> Stephen De Gabrielle
>
>
>
>
> _______________________________________________
> fossil-users mailing list
> [email protected]
> http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
>
>
--
D. Richard Hipp
[email protected]
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
