Adding Fractional Seconds in Time Values?

[Mats]

I was asked if I could help my daughter's track and field club organize a database with all the results throughout the club's history. My response was of course: I'll fix it with PW. 
After digging into the subject a bit, I realize that I will need "Fractional Seconds in Time Values" for the race results. 
Is this something that could be added to the date/time field type or is it better to create a separate field type for this purpose?

https://w3c.github.io/opentrack-cg/spec/model/#time

https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html

[Mats]

I found @netcarver's module PW-FieldtypeTime. I'll see if it's possible to extend the functionality of the module.

[netcarver]

Although I never thought of this use-case, it should be possible as the module uses (IIRC) the MySQL Time type which does have fractional second support.

[BrendonKoz]

The FieldtypeMeasurement module might be another option (I haven't used it myself yet, but it appears to offer time conversion). It may need some massaging to allow the interface to behave the way you want, but I'd think it would assist you quite a bit. I saw in the module's README that it has second, minute, hour, day; I just don't know if it offers (out-of-the-box) microseconds. The combination input values might not default to the formatting you'd want to provide end-users.

Honestly, I'd probably just use a text field and handle the calculations myself, unless they have strict database requirements or comparisons that you'd need to do in the future. Just in case this is useful for your project (referencing a now-fixed rounding issue with Float values in PW): 

 

[Mats]

Thanks @BrendonKoz! Will check this out. 

[JanetMahon]

On 11/4/2025 at 12:51 AM, BrendonKoz said:

The FieldtypeMeasurement module might be another option (I haven't used it myself yet, but it appears to offer time conversion). It may need some massaging to allow the interface to behave the way you want, but I'd think it would assist you quite a bit. I saw in the module's README that it has second, minute, hour, day; I just don't know if it offers (out-of-the-box) microseconds. The combination input values might not default to the formatting you'd want to provide end-users.

Honestly, I'd probably just use a text field and handle the calculations myself, unless they have strict database requirements or comparisons that you'd need to do in the future. Just in case this is useful for your project (referencing a now-fixed rounding issue with Float values in PW): 

 

Thank you, you made my day.