On 5/22/2013 6:48 PM, Stephan Buchert wrote:
It seems that I failed to make the point clear:
On June 30, 2012 the 86401st second happened in the real world
I think you mean "a second was artificially added by some, but not all
or even most, people to some, but not all or even most, calendar
calculations". I'm pretty sure no singularity point occurred in
space-time continuum on that date.
it was
working time in parts of the US. In this second there were financial
transactions, photos were taken, sensors delivered data, etc etc, events
that users might want to insert into databases with a correct time stamp,
and where the seconds might matter.
Most of those transactions, photos, and sensor data were reported by
devices that were blissfully unaware of leap seconds, and never produced
any timestamps with seconds outside of 00-59 range. At best, some of
those devices, e.g. GPS receivers, might have noticed that their clock
was a bit off, and adjusted it accordingly.
Leap seconds simply don't arise in practice, outside perhaps of a few
specialized applications (astronomical calculations and such) - as
witnessed by the pronounced lack of sympathy you have experienced in
this thread.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
