Hi D. Richard Hipp, After read the document, I still no sure how can I import/convert from the other Database's data using these command sets.
For example if I wanted to import data from CSV, with the date format of MM/DD/YY, how the query statement like, if I want to insert to SQLite with the Date And Time functions Insert Into ABC Values( "12/29/03","KLCHIN","Bye Bye 2003" ); Insert Into ABC Values( "1/2/04","KLCHIN","Happy New Year 2004" ); Is there any fucntion that direct convert like this Insert Into ABC Values( CvtDate(1/2/04,YY/MM/DD,YY/MM/DD) ,"KLCHIN","Happy New Year 2004" ); This funciton CvtDate was currently use to reconstruct the SQL statement b4 insert into SQLite. Thx in advanced. Regards KL Chin -----Original Message----- From: D. Richard Hipp [SMTP:[EMAIL PROTECTED] Sent: Friday, January 02, 2004 11:38 AM Cc: '[EMAIL PROTECTED]' Subject: Re: [sqlite] Date problem KL Chin wrote: > > Is that away to have a "DATE" comparison inside SQLite? > Or any expression to convert DATE to integer in SQLite? > I mean, I don;t have to worry about data migration from other > database. > http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions -- D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
