Skip to content

[BUG] Non-Localized Time #467

@SturmB

Description

@SturmB

Describe the bug
The month number is off by 1 and the time is UTC.

To Reproduce
Export anything involving a date/time, such as the Added field.

Expected behavior
For the month number, I would expect the month number to be correct (1 = January, 2 = February, etc.).
For the time, I would expect it to be auto-adjusted to the local time zone and possibly even corrected for Daylight Savings. Or, at least I would expect an option in Settings to choose between UTC and Local time.

Screenshots
image

Desktop (please complete the following information):

  • OS: Windows 11, latest build as of this writing.

Additional context
In the screenshot above, note that "An American Tail" was added to my library on "2022-00-27 11:32:25". This is obviously incorrect. It was actually added on "2022-01-27 06:32:25" in my time zone.

The month number is clearly using a zero-based index, so it should be incremented by one before export.

As for adjusting for the local time zone, I don't know what you'd need to do to make that happen. I just know that I can use a SQL function strftime() and add 'localtime' as the third argument to that function in order to automatically convert it. It will even take care of rolling back the day when it crosses midnight and even the month if it happens to fall on the last day of the month, too.

Logs
I do not know how to provide the logs from WebTools-NG, as I see no option for it in menus, nor do I know where it stores its logs. I doubt they are needed for this issue, anyway.

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions