If you are attempting to save a date in iOSSQLiteDatabase into a DateTime or Timestamp field and using the built in parameters be careful! I found out today that if you pass in a Xojo.Core.Date object in it will drop the seconds portion. If you pass in the full string it works just fine.
Didn’t matter if the field type was Timestamp or DateTime. Both field types dropped the seconds.
Not sure if this is a bug or ‘just the way it is’, but thought I’d document it for others.
Not exactly an ideal solution since SQLite happily stores and queries against the SQL Date Time (with seconds). The double isn’t human readable either if you want to work with the database.
[quote=319997:@Bob Keeney]Not exactly an ideal solution since SQLite happily stores and queries against the SQL Date Time (with seconds). The double isn’t human readable either if you want to work with the database.
To me, this seems like it might be a Xojo bug.[/quote]