does that mean. i just create "timedate int" in sql. and use unixepox to store the date+time inside it. and query it using unixepox for range ?
select * from table1 where timedate >= unixepox_number1 and timedate <= unixepox_number2; is this correct? thank you. --- [EMAIL PROTECTED] wrote: > 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 > __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail