Thanks. > There is no Time type in SQLite.
Oops... I use Sqlite Administrator to create a table , and the datatypes are almost as many as MySQL , such as Date, Time, TimeStamp, varchar. Since sqlite only has 5 kinds of datatype, why doesn't it throw a error message when I create a table with a wrong datatype? > I bet you don't actually use quotes as you show above. In fact, I have used in the sql code. -------------------------------- Say goodbye to romance... On Fri, May 15, 2009 at 8:37 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > "Hughman" <hugh...@gmail.com> wrote in > message > news:f1a32add0905150528r3bc74b2epd7ab93539ac68...@mail.gmail.com<news%3af1a32add0905150528r3bc74b2epd7ab93539ac68...@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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users