Ah yes, forgot about that! I looked in Sarah's date routines and found what I'm looking for.... BUT - it says the base date is January 1, 4713 BCE and SQLite says the base date is 11/24, 4714 BC, a few months after Sarah;s base date.
Maybe I'll just give it a whirl and see what happens. Pete Haworth On Mar 2, 2011, at 4:28 PM, Alex Tweedly wrote: > "When it's important, go to Sarah's site." (with apologies to M&S :-) > > http://www.troz.net/rev/index.irev?category=Library#stacks > > -- Alex. > > > > On 03/03/2011 00:20, Peter Haworth wrote: >> Why do I keep getting involved in these off-the-wall topics! >> >> I have a need to convert dates back and forth between the formats used by >> sqlite and human readable formats. LC has me covered for text string dates >> and dates stored in seconds but SQLIte can also store dates in Julian >> format, defined as the number of days since 11/24, 4714 BC. I guess it's a >> matter of conjecture as what's significant about that date but aside form >> that, I can't find anything in he LC dictionary that leads me to believe it >> can deal with dates in that format. Anyone come up with a way to deal with >> Julian dates/ >> >> Pete Haworth >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
