Andre du Plessis wrote:
select date_modified from table where julianday(date_modified) >
julianday(CURRENT_TIMESTAMP) - 1;
this seems to work perfectly, for some reason the function can simply
convert the text successfully, not sure how it's able to do that, but
impressive,
Is there anyway to round off the datestamp to the beginning of the day,
or maybe do you know if there is a list of built-in date functions
somewhere?
Andre,
Check out this page
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
I'm sure it will clear up lots of your questions.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
