Actions
Bug #651
openBug #635: 2nd round test
Timezone mismatch between PostgreSQL and SQLite for order timestamps
Start date:
03/25/2026
Due date:
% Done:
0%
Estimated time:
Description
Order timestamps are stored and displayed in different timezone formats across databases:
PostgreSQL: 2026-03-25 13:05:33 +05:30
SQLite: 2026-03-25 07:35:33 +00:00
Both timestamps represent the same moment but are shown in different formats, causing confusion. The system should standardize datetime format across all databases (either consistently in UTC or a single timezone format) and ensure uniform display throughout the application.
Actions