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 > message when I create a table with a wrong datatype?
Igor previously indicated (above) that there is no time type in SQLIte. However, he also said: > For more details, see http://sqlite.org/datatype3.html Based on your question about errors not being thrown, you apparently did not read the above link for the details; if you had you would realize no error is thrown because no error has occurred. SQLite does not use static typing, like mySQL and most others, it uses manifest typing. Read the link and all will be clear. Chris _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users