Re: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-14 Thread John Stanton
We just lifted the routines out of Sqlite to do that. They are in date.c. By making an Sqlite-style date type and a small library of date manipulation routines we move date conversion to the application. It is handy when handling ISO8601 and HTTP date formats plus integrating with file agees

RE: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-13 Thread Rob Richardson
Dr. Hipp, Thank you very much for the link to the source for the Julian date calculations. I did pull the code out of date.c, and I'm using it. But the code seems to rely on implicit conversions between floating-point numbers and integers that I assume must be intentional, but it looks error-pro

RE: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-13 Thread Griggs, Donald
Hi Rob, Regarding: One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my application. I may not understand your request fully, but are you asking for more information than is provided in the source files for the con

Re: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-13 Thread drh
"Rob Richardson" <[EMAIL PROTECTED]> wrote: > > I didn't see any little utility function in the SQLite library that just > exposes whatever routine SQLite uses to do the conversion. Does one > exist? > The complete source code for the routines SQLite uses to do this conversion are in the source

RE: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-13 Thread Rob Richardson
All right. Smack me upside the head again. I deserve it. SQLite is open source, so I just had to look in the source code. RobR - To unsubscribe, send email to [EMAIL PROTECTED] --

Re: [sqlite] How can I convert from Julian time to a tm structure?

2007-06-13 Thread Gerry Snyder
Rob Richardson wrote: ... One thing I want to do is to move the conversion of the timestamp from a Julian time to a human-readable time from the query to my application I didn't see any little utility function in the SQLite library that just exposes whatever routine SQLite uses to do the co