I'm creating reports utilizing openNTF's domSQL/JDBC driver for Domino (powered by SQLite). It enables us to use Domino's databases as SQL database views. One of the features of this driver is that it converts all the Domino db date fields to text fields. Somehow, in doing this, it converts the date 'xxxx-03-01 xx:xx:xx' to 'xxxx-02-29 xx:xx:xx'. Not only is the date incorrect, but 2/29 is a leapyear date being assigned to non-leapyears. This is causing an additional error when we attempt to store this invalid date into a date field.
More info on DomSQL can be found here: http://ift.tt/1B5qymo$file/DominoJDBCAccess.pdf
Aucun commentaire:
Enregistrer un commentaire