Gerry Snyder wrote:
> Harold Wood wrote:
>> I have several tables that i need to datestamp as transactions occur and
>> then retrive with a select where between X and Y.
>>
>> What is the best way to do this in SQLite?
>>
> Look at
>
> http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
>
> and ask again if you have further questions.
You might also want to look at using triggers to auto insert the
datetimestamp as your entries are inserted/updated.
John
--
Regards
John McMahon
[EMAIL PROTECTED]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
