On Tuesday 22 April 2014 12:38:24 andy pugh did opine: > On 22 April 2014 16:23, Gene Heskett <ghesk...@wdtv.com> wrote: > > What sort of contortions are required to fully recover a number stored > > in SQLite as text? > > Why would you need to?
Something in the back of my mind, possibly from a past life, tells me there are often rounding errors in the recovery unless it is stored as the fprintf %ld format. But the memory is faint, goes back to writing an eclipse finder in C probably 20 years back up the log. I think, but cannot prove that when using the julian calendar, the backwards math chokes and upchucks all over itself somewhere around may or june 4713 BC. The original truebasic program I translated it from also suffered a similar fate IIRC, as was noted in the BYTE magazine article giving the truebasic code listing. That is apparently the origin time of that calendar, equ to the unix 1/1/1970, but it doesn't do negative numbers at all well. Possible moot for this application if enough digits are stored. AT least a double double (16 or 17 digits) stored as a double float should be ok. Cheers, Gene -- "There are four boxes to be used in defense of liberty: soap, ballot, jury, and ammo. Please use in that order." -Ed Howdershelt (Author) Genes Web page <http://geneslinuxbox.net:6309/gene> US V Castleman, SCOTUS, Mar 2014 is grounds for Impeaching SCOTUS ------------------------------------------------------------------------------ Start Your Social Network Today - Download eXo Platform Build your Enterprise Intranet with eXo Platform Software Java Based Open Source Intranet - Social, Extensible, Cloud Ready Get Started Now And Turn Your Intranet Into A Collaboration Platform http://p.sf.net/sfu/ExoPlatform _______________________________________________ Emc-users mailing list Emc-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/emc-users
