I see that it is a variant of type VT_BSTR containing
"2345678.9123" (or whatever), and I have to use strtod() to convert it
to the number I want. Is there a way to write the query to ensure that
it will give me a number instead of a string?
The type selection is done in your ODBC wrapper, and
I believe ODBC will do type conversions for you. If not, use sscanf.
All sqlite data is stored as strings, I believe, anyway, so there's lots
of type conversion going whether it's explicit or not.
Representing dates as floating point numbers can be tricky because of
subtle rounding issues,
Greetings!
I am trying to talk to a small SQLite database through ADO and an ODBC
driver. I want to convert a date to a Julian day before using the date
in a query of a table that could have over a million records. In
SQliteSpy, the query "SELECT julianday('2007-06-05 12:34:56',
'localtime')
3 matches
Mail list logo
