"Rich Shepard" <rshep...@appl-ecosys.com> schrieb im Newsbeitrag news:alpine.lnx.2.00.0908031516300.3...@salmo.appl-ecosys.com...
> > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
