Microsecond precision

[zifeo]

When working with sql type DATETIME(6), how can we keep microsecond precision and avoid joda time millisecond restriction?

[mirabout]

Just cast the desired Sql result column to an integer of an appropriate size and expect an integer object on the user side.

[mirabout]

In general, you can decompose a date in Sql query and return the date as a list of separated integer columns if you want to bypass joda time representation.