Skip to content

LocalDate with UTC timezone instead of system default #1305

@toth-istvan-zoltan

Description

@toth-istvan-zoltan

As of now, LocalDate is converted into milliseconds with the system default timezone: JavaDateColumnType.kt

This does not work in our use case where:

  • we use Exposed on servers, on Android devices, on Raspberry PI devices,
  • we transfer SQLite databases between these.

With system default timezone there is no guarantee that the day will be the same on different devices.

Using UTC for the millisecond conversion would solve this problem, but changing the current behaviour might break existing installations.

What would be the best way to add the option to use UTC? If it can be a general solution I'll put it into a pull request of course.

Thank you for your help.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions