"Rich Shepard" <[email protected]> schrieb im Newsbeitrag news:[email protected]...
> > It was set as String actually. > > Rick, > > That's the storage class; well, TEXT is the storage class. Yep. > > I believe this is a WRAPPER thing though. Exactly. The COM-wrapper handles Date-Column-Definitions which are "declared" in the Create Table Statement as "..., MyDate Date, ..." or "..., MyShortDate ShortDate, ..." with something like an "auto-mapping" to the appropriate vbDate Variable-Type (which at binary-level, in the language is a Floatingpoint-Type with Double-precision - counting the days since 1899-12-30, with the "percentage of a day" encoded in the fractional part of this floatingpoint-number). So, it's the wrapper who maps vbDate-Types to the SQLite-engines Text-storage-class (using the standard-SQL "textdate-format", 'yyyy-mm-dd' for ShortDates and 'yyyy-mm-dd hh:mm:ss' for "full dates". The SQLite-engine itself does not know about these "VB-Double-DateTypes "the wrapper hands out to the application. Just to shade some light on the topic... ;-) Olaf _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
