THANK'S A LOT IGOR Igor Tandetnik escribió: > 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 >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users