If you read <http://www.sqlite.org/datatype3.html> you will see that, "Each value stored in an SQLite database (or manipulated by the database engine) has one of the following storage classes:
NULL. The value is a NULL value. INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value. REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number. TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16-LE). BLOB. The value is a blob of data, stored exactly as it was input." All dates are stored as strings, however, useful datetime functions are provided to manipulate those strings. Alternatively, you could store the timestamp as seconds since the epoch. In that case, they would be an integer and you could always convert them into date strings. To summarize, all you have is NULL, INTEGER, REAL, TEXT, and BLOB, and probably some of the purists would say that is 5 types too many. On 5/31/07, Mitchell Vincent <[EMAIL PROTECTED]> wrote:
I have a set of databases that contain a date type called "timestamp". I need to make those "integer" so they come through the ODBC driver the right way. Is there any way to change all of that through queries on-the-fly? I'd like to avoid re-creating all the databases if possible.. Thanks! -- - Mitchell Vincent - K Software - Innovative Software Solutions - Visit our website and check out our great software! - http://www.ksoftware.net
-- Puneet Kishor http://punkish.eidesis.org/ Ph.D. Program, Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ Vice-President, Open Source Geospatial Foundation http://www.osgeo.org/ S&T Policy Fellow, National Academy of Sciences http://www.nas.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
