Have you considered using the date functionality supported by SQLite? http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
-----Original Message----- From: teoh [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 4:22 PM To: sqlite-users@sqlite.org Subject: [sqlite] sqlite search by "DATE" range ? hi, i created date_year smallint,date_month smallint, date_day smallint, time text in sqlite database. does anyone knows algorithm use to quote date range? let say, user wants to quote for result from 20-12-2004 until 14-1-2005 ? (dd-mm-yyyy) thank you for clarifying. __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail
