Re: [sqlite] About Time Field

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

Re: [sqlite] About Time Field

On Fri, 15 May 2009, Hughman wrote: >> 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 >

Re: [sqlite] About Time Field

Hughman wrote: >> 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

Re: [sqlite] About Time Field

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

Re: [sqlite] About Time Field

"Hughman" 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

[sqlite] About Time Field

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