Never mind, just realised that SQlite can do all the conversion for me. Pete Haworth
http://www.mollysrevenge.com http://www.sonicbids.com/MollysRevenge http://www.myspace.com/mollysrevengeband On Mar 2, 2011, at 5:26 PM, Peter Haworth wrote: > 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 >
_______________________________________________ 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
