Carlos Suarez <carlos.sua...@rolsoft.com> wrote: > An date field can be null or not, depending of this the field it > writes 'without_a_date' or the number of days from a date to another > *the problem is only the presentation cause I need the subtract > without decimals number* but round doesn't work here because the > result is "without_a_date" or ie: 34.0 or any number with period and > zero, I need only 34 in that case or 'withoutadate'
Try CAST(round(...) as integer) Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
