That works beautifully. s.
On Mon, Mar 7, 2011 at 1:05 PM, Richard Hipp <[email protected]> wrote: > > > 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 > > -- -- Stephen De Gabrielle [email protected] Telephone +44 (0)20 85670911 Mobile +44 (0)79 85189045 http://www.degabrielle.name/stephen
_______________________________________________ fossil-users mailing list [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
