Timestamp currently doesn't handle fractional seconds part

[geomaniac]

This means inserting a date like 2018-09-14T12:33:21.831371900 will be stored and later retreived as 2018-09-14T12:33:21.

This is caused by us using SQLT_DAT as host type, which doesn't have below second precision.

Possible solution 1: Use strings

Using SQLT_CHR and use the standard string representation to convert between NativeDateTime and Timestamp.

Need to set NLS_TIMESTAMP_FORMAT to set the format correctly. Like so:

ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'YYYY-MM-DD"T"HH:MI:SS.FF';

Possible solution 2: Use oci datetime class

Using SQLT_TIMESTAMP and OCIDateTime .

https://docs.oracle.com/database/121/LNOCI/oci12oty.htm#LNOCI16842