"Hughman" <hugh...@gmail.com> wrote in message news:f1a32add0905150528r3bc74b2epd7ab93539ac68...@mail.gmail.com > I create a table with a field of datatype Time
There is no Time type in SQLite. For more details, see http://sqlite.org/datatype3.html > and when I insert a > formatting string like 'HHMMSS' into it , the first number 0 always be > trimed . I bet you don't actually use quotes as you show above. In which case, what you store is an integer. Naturally, 012345 = 12345. Consider storing a string in HH:MM:SS format instead. That would allow you to use built-in date/time functions if you ever need to perform time arithmetic on this field: http://sqlite.org/lang_datefunc.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
