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.
Rob Richardson wrote:
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 application. (By the way, this is a C++ app written in MS Visual
Studio 6.) I could build a query and have SQLite execute it, something
like "SELECT datetime(123456.789) AS timestring", but that has the
overhead of preparing the query, executing it and finalizing it, plus
the overhead of converting from a string representation into the tm
structure once I get the result of the query.
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?
There must be plenty of algorithms out there to do this conversion. A
quick search revealed a few, but they were obviously faulty (assuming
every year has 365.25 days, for instance) or not precise enough
(returning only the day). I need an algorithm that is accurate to the
nearest second. What should I use? Or is the SQLite query the best I'm
going to do?
Thank you very much.
Rob Richardson
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
