Hi, With regard to these new date/time functions as pointed out at:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions I have one question: I can't seem to be able to use them on actual datetime field in the database. For instance, my test script as below: create table test(a int, b datetime); insert into test values(1,'2004/1/3'); select * from test where date(b)='2004/1/3' The SELECT statement returns no record. Similarly, the statement: select date(b) from test does not return anything either. Perhaps I misunderstood the usage of those functions? Thanks for any help. Eugene Lin *********** REPLY SEPARATOR *********** On 01/01/2004 at 10:38 PM D. Richard Hipp wrote: >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]