On Mon, Jun 15, 2020 at 01:23:06AM -0500, Jeff Gray wrote: > Maybe I should just be asking what people normally do to store dates in > SQLite. (I'm guessing there aren't that many...)
The Pharo SQLite binding stores DateAndTime instances as strings. When fetching from the database, if the declared column type looks date/time-ish then that string is turned back into a DateAndTime instance. See this blog post: https://www.samadhiweb.com/blog/2015.04.09.nbsqlite3.datetime.html The blog post refers to NBSQLite3Connection, which is for the Pharo 4 NativeBoost FFI version. Current version is here: https://github.com/pharo-rdbsm/Pharo-SQLite3 I've entertained the idea of making it pluggable, so that the application programmer gets to decide whether to store/fetch Unix epoch integers, Julian day floats, etc. No action, daydreaming only. Pierce
