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
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
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
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]
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
Greetings!
I am trying to speed up an application that queries a table with three
columns and around a million records, and one of the fields is a
timestamp. 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
6 matches
Mail list logo
