Re: [sqlite] Reading datetime fields in a C++ program

2009-03-31 Thread Radcon Entec
I was able to answer my own question.  Because SQLite is typeless, any random collection of bytes can be stored in any field.  So, I have no guarantee that the information stored in the value_timestamp field actually represents a double-precision floating-point number.  Those fields might actual

[sqlite] Reading datetime fields in a C++ program

2009-03-31 Thread Radcon Entec
I am using a program writing in C++ using MS Visual Studio 6 to read a SQLite table.  The table's create statement, as reported by SQLiteSpy, is: CREATE TABLE trend_data( tag_key integer, value integer, value_timestamp datetime ); I am trying to retrieve the largest value of the value_timestamp