Re: [sqlite] Very simple table...

Hi Scott, > I'm trying to decide whether LogDate should be in unixtime > format, or raw date format ('2008-01-01 13:12:11'). I use juliandate (real) to store the dates. See this web page for details: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Tom BareFeet

[sqlite] Very simple table...

I have a very simple table: CREATE TABLE Log ( LogDate, LogText ); Just when did the event happen, and what was it. So now I'm populating the fields and I'm trying to decide whether LogDate should be in unixtime format, or raw date format ('2008-01-01 13:12:11'). I'm assuming