Sqlite does not have a TIME type.. It is interpreting your time as an integer or floating point number or maybe text, depending upon its format.
Hughman wrote: > Hi, > > I create a table with a field of datatype Time, and when I insert a > formatting string like 'HHMMSS' into it , the first number 0 always be > trimed . I want to keep it, how should I do? > For exampe, '081220' will be converted into '81220'. > > > -------------------------------- > Say goodbye to romance... > _______________________________________________ > 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