IQ Driver - MariaDB - Fractional Seconds
Using MariaDB 10.1.14, XtraDB storage engine.
Latest LinqPad and IQ Driver.
I have a table with a column of type DATETIME(3).
When i try to insert a record from LinqPad that a DATETIME with fractional seconds (e: 2016-06-29T02:46:43.273) the fractional seconds are lost. I tested inserting records from HeidiSQL with fractional seconds and that worked fine. The above time stamp was copied out of LINQpad so I know the value is there.
Does anyone know if the IQ driver supports fractional seconds or am I doing something wrong here?
Latest LinqPad and IQ Driver.
I have a table with a column of type DATETIME(3).
When i try to insert a record from LinqPad that a DATETIME with fractional seconds (e: 2016-06-29T02:46:43.273) the fractional seconds are lost. I tested inserting records from HeidiSQL with fractional seconds and that worked fine. The above time stamp was copied out of LINQpad so I know the value is there.
Does anyone know if the IQ driver supports fractional seconds or am I doing something wrong here?