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