Zero Before Decimal

[Jerry Osborne]

I am working with a table that has a milliseconds field that is intended to CONCAT with a time field. The intention is to work around the limitation of the Time type so that I can store milliseconds, concat them and the work with them in this format hh:mm:ss.mmmm. I am loading data from a file but the Msec field is adding a 0 before the value being inserted so I end up with 0.xxxx instead of .xxxx.

As you can imagine, the CONCAT is just wrong as it is sticking the unnecessary zero in there.

In loading the file, I have tried to enclose the value in 'value' but it still behaves the same way.

So, my question is what can be done? Is there a way to force the field to maintain the original format? Is there something I can do with the upload (.csv) file? Is there a way to remove the zero format he field once the data is in the table?