On 28 Dec 2009, at 8:07pm, Alexey Pechnikov wrote: > On Monday 28 December 2009 21:29:48 Simon Slavin wrote: > >> yyyymmdd (if you need just a date) >> hhmmss (if you need just a time) >> yyyymmddThhmmss (the date, then a 'T', then the time) > > Hm, you did forget the simplest way - to use unixepoch format. > And this is very compact too.
I agree that this is often an acceptable alternative. But * it's hard to decipher if you're reading the data by eye * the system does not deal with leap seconds correctly * the system terminates in 2038 (if you use Unix's old 32-bit standard) * one day you may need to read the data on a non-unix platform Nevertheless, if your data starts off as a Unix epoch, it can be fast and convenient to just store it without having to do any conversion. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
