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