Timezone argument in Settings

[Besthope-Official]

Use Case

TimestampMixin creates timestamp at UTC time

        "created_at": "2026-01-07T16:29:08.308836+00:00",
        "updated_at": "2026-01-07T16:29:08.308870+00:00",

should support UTC+8 time

Proposed Solution

provide a timezone specific argument in settings, and a timezone specific factory function in mixin

Alternatives Considered

• config at db level?

Implementation Notes

N/A

[Besthope-Official]

This is an anti-pattern: databases should store UTC timestamps only. Timezone conversion belongs in presentation layer, not storage

WHY? Storing timezone-offset timestamps breaks datetime comparisons (UTC vs UTC+8 equality fails), creates ambiguity during DST transitions, and fails when timezone rules change historically—UTC storage is absolute, portable, and comparable across all records.

if you need a serialized time, do this in API serialization (you can do this in a middleware).

#88 this pr already introduced this into main, so a revert pr will be made.