Hi Marcel, Yes, that sounds like a bug. I've cc'd the current maintainer of that module, Mike Wisener, but I'd also suggest reporting the bug via rt.cpan.org at https://rt.cpan.org/Public/Dist/Display.html?Name=DateTime-Format-MySQL
Cheers, Dave Rolsky http://blog.urth.org https://github.com/autarch On Wed, Jul 5, 2023 at 3:03 PM Marcel Versteeg via datetime < datetime@perl.org> wrote: > The DateTime::Format::MySQL formats microseconds incorrectly in the method > format_time. It simply concatenates the number of microseconds after the > formatted hms, however this is incorrect when the number of microseconds is > less than 100,000. > > If a date object returns 12,345 microseconds at 5 am, the function > format_time returns 05:00:00.12345, but it should return 05:00:00.012345 > (mind the '0' between the period and the 1). > > Another example would be if the number of microseconds is 1 at 6 am, where > format time returns 06:00:00.1, but instead it should return 06:00:00.000001 > > Sincerely, > Marcel Versteeg > > >