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?
Cheers,
Stephen
--
Stephen De Gabrielle
_______________________________________________
fossil-users mailing list
[email protected]
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
