Since SQLite officially recomends storing dates as the julian day number, would it be possible to support this in a future release? The Julian day number conversion is actually pretty trivial. Julian Day Numbers and OLE Automation dates are both stored in the same format but cover a different range of years and define a different begining of the day. 0 in OA Dates is 2415018.5 in Julian Day Numbers.