You could hack the result set class to add the functionality you describe to work with your date columns. But a general solution is not possible due to the lack of a proper date type in SQLite. Internally dates are stored as text, and retrieved using a programmer defined convention (which may vary between sqlite databases).
http://www.sqlite.org/cvstrac/wiki?p=ProposedIncompatibleChanges > PrepStmt.setObject() - ignores date parameter therefore setObject() > and setDate() stores dfferent values in the database. > > RS.getObject() - won't return a date even if setDate() was called > during insert (getColumnType() won't return a date either). > getObject() uses column_type() which won't return a date, but > column_decltype() will retrurn a string from which a type can be > deduced. ____________________________________________________________________________________Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. http://new.toolbar.yahoo.com/toolbar/features/mail/index.php --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLiteJDBC" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlitejdbc?hl=en -~----------~----~----~----~------~----~------~--~---
