"Hughman" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
