teoh <[EMAIL PROTECTED]> writes: > 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)
This page contains all of the information about supported date and time functions in SQLite: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions You'll probably want to save your dates as a single number for ease of manipulation and comparison. If all you care about are dates (i.e. without associated times during the day), then you can use the Julian day number, "%J" in the strftime() documentation. If you need times as well, then a convenient format may be the Unix epoch value, the number of seconds since 1970-01-01 at midnight, "%s" in strftime(). Derrell
