Re: DateTime::Format::MySQL format_time incorrect

2023-07-05 Thread Dave Rolsky 
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.01
>
> Sincerely,
> Marcel Versteeg
>
>
>

DateTime::Format::MySQL format_time incorrect

2023-07-05 Thread Marcel Versteeg 
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.01

Sincerely,
Marcel Versteeg