That was my concern. I guess it doesn't matter as long as you use the same
base date for conversion to and from Julian format, and once I found SQL
provides functions to do that, I realised I don;t need any LC code.
Pete Haworth
On Mar 3, 2011, at 8:55 AM, Bob Sneidar wrote:
> http://en.wikip
http://en.wikipedia.org/wiki/Julian_day
Apparently there are a number of different Julian Date forms. Kind of makes you
wonder why anyone uses it at all!
Bob
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
Gee, I wonder what happened on that date?
Bob
On Mar 2, 2011, at 4:20 PM, Peter Haworth wrote:
> 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.
_
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
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
"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 b
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
