Re: [sqlite] Timestamp DataType

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.

Re: [sqlite] Timestamp DataType

lt;sqlite-users@sqlite.org> Sent: Friday, May 16, 2008 10:12:54 AM Subject: Re: [sqlite] Timestamp DataType 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

Re: [sqlite] Timestamp DataType

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 . Datatypes aren't strictly enforced like other databases. If you insert the date as a format SQLite

[sqlite] Timestamp DataType

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,