A timestamp is a REAL. Joanne Pham wrote: > Hi All, > As mentioned in the document of SQLite the list below is all the datatype of > SQLite. > How about Timestamp fromat? Can we havethe column's datatype as Timestamp . > Thanks, > JP > * NULL. The value is a NULL value. > * INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 > bytes depending on the magnitude of the value. > * REAL. The value is a floating point value, stored as an 8-byte IEEE > floating point number. > * TEXT. The value is a text string, stored using the database encoding > (UTF-8, UTF-16BE or UTF-16-LE). > * BLOB. The value is a blob of data, stored exactly as it was input. > > > _______________________________________________ > 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
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
