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 unixtime would store as less bytes? Are there any inherent speed advantages either way? Do the date functions work faster on either one? -- Scott Baker - Canby Telcom RHCE - System Administrator - 503.266.8253 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users