It is ok even if use local time, because using UTC will let thing getting complex.
--- "Ted Rolle Jr." <ster...@gmail.com> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > And in addition, the TZ offset might be handy to convert to UTC. > Local > time is locally determined while UTC is constant, and other local > offsets can be applied to display time in local terms. > For example, EST is UTC-5; EDT is UTC-4; PST is UTC-8; PDT is UTC-7; > During WWII there was a ``War Time''. Some countries have a > half-hour > offset in addition to the hour offset, so 2010-09-03T09:10:12+4:30 is > a > valid time. It's _all_ politics; this makes it subject to the whim > of > each government. So, in addition to the half-hour offsets, time-zone > offsets may change. Also, the determination of Daylight Savings time > varies by country and can correspondingly change. UTC is best. > That's > the reason Unix uses seconds since 1970. I don't know what they do > for > dates before that; if the time can have a negative offset (proleptic) > then all is well. > > Hmmm...Ask me the time; I'll give you my watch. :-) > > Ted _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users