OrmLite storing DateTime with ms precision in MySql

ServiceStack.OrmLite MySql
1

By default DateTime persisted to MySql using OrmLight have second precision.

Is there a way to persist DateTime with millisecond precision?

Thanks.

2

You can change the MySql Column Type used with a [CustomField] attribute to use a MySql DateTime type with fractional seconds precision, e.g. DateTime(fsp).

3

I’ve just added support for specifying a precision by modifying the DateTime converter, e.g:

if (MySqlDialect.Provider.GetConverter(typeof(DateTime)) 
    is MySqlDateTimeConverterBase dateConverter)
{
    dateConverter.Precision = 3;
}

This is now available in the latest v5.10.4 that’s now on NuGet.

4

You Sir rock. Thanks. The attribute worked well.

1 Like