Thanks John, " If you make it a REAL instead of DATETIME your code will be clearer." So you meant that I should make my datatype as REAL instead of DATETIME. Thanks, Joanne
----- Original Message ---- From: John Stanton <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, December 17, 2007 10:00:11 AM Subject: Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER. If you declared your date and time (timestamp) column DATETIME it will be floating point and will store date and time in 8 bytes. Use the FP bind function. If you make it a REAL instead of DATETIME your code will be clearer. Joanne Pham wrote: > Hi All, > I have two question regarding DATETIME column data type: > 1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier > if this column type is INTEGER vs DATETIME then > do the conversion in the GUI code to convert from INTEGER TO DATETIME. > > 2) And if I store as DATETIME then What is the command to bind this > column type as DATETIME. > For the INTEGER the bind command is : sqlite3_bind_int but I don't know > if the column is DATETIME > then what is the command to bind this column. > Thanks, > JP > > > ----- Original Message ---- > From: P Kishor <[EMAIL PROTECTED]> > To: sqlite-users@sqlite.org > Sent: Thursday, December 13, 2007 2:48:26 PM > Subject: Re: [sqlite] create table with datatype = DATE > > CREATE TABLE test (.. createData DATETIME DEFAULT CURRENT_TIMESTAMP) > > On 12/13/07, Joanne Pham <[EMAIL PROTECTED]> wrote: >> Hi All, >> I create the table as : >> create table test (name varchar(30), createDate DATE default >> DATETIME('NOW')); >> but I got the error message. I want to have the default as now if it is not >> specify. >> Thanks in advance, >> Joanne >> >> >> >> ____________________________________________________________________________________ >> Never miss a thing. Make Yahoo your home page. >> http://www.yahoo.com/r/hs > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] ----------------------------------------------------------------------------- ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ