Julian Days and Eon seconds

Peter Haworth pete at mollysrevenge.com
Wed Mar 2 21:32:41 EST 2011


Never mind, just realised that SQlite can do all the conversion for me.

Pete Haworth

-------------- next part --------------






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 at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
> 



More information about the use-livecode mailing list