The problem not having a DATETIME field is, however, very simple: When reading a foreign database which stores date values as a number, I have to guess on how to get back the correct date.
The datatype used is irrelevant w.r.t. this issue. Unless fully qualified with convention used and possibly location on Earth, you have no way to say it's local time (requires location), Zulu time, Hebrew calendar (requires location), islamic calendar (which version?), fiscal (which version/country?), TAI, whatever. There exist a large number of conventions and variants for denoting datetime.
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
