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 actually contain a
character string representing the date and time. I deleted all but five
records from the trend_data field, vacuumed the database, and then opened the
database file in a binary editor. Sure enough, I found the text representation
of the datetimes in the file. So, until I can ensure that I control the format
of the data being written into the table, I will need to use either julianday()
or datetime() to ensure I know the format of the data as I am reading it from
the table.
Rob Richardson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
