> #2 is non-standard. No time value. when I select, I will use days * 3600
> #3 has no time value. '2010-09-03T01:23:45' (ISO 8601) would be an > option though. I will convert it to Date when select > #4 gives room for mistakes; the year may be interpreted as the day. maybe you are right. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users