josh/Catalyst
1
0
Fork 0
Code Issues 2 Pull Requests Actions Packages Projects Releases 16 Wiki Activity

fix: parse SQLite timestamps as UTC, not local time #30

Merged
josh merged 1 commits from fix/sqlite-utc-timestamps into dev 2026-03-28 15:20:15 -04:00
Conversation 0 Commits 1 Files Changed 2
+26 -6
josh commented 2026-03-28 15:19:59 -04:00
Owner
Copy Link
Copy Source

SQLite datetime('now') returns 'YYYY-MM-DD HH:MM:SS' with no timezone
marker. JS was treating this as local time, so timestamps showed the
correct UTC digits but with the local TZ abbreviation attached (e.g.
'7:15 PM EDT' when the real local time was '3:15 PM EDT').

Add parseUtc() which appends 'Z' before parsing any string that has no
existing timezone marker, ensuring JS always treats them as UTC before
the display-timezone conversion is applied.

Co-Authored-By: Claude Sonnet 4.6 noreply@anthropic.com

SQLite datetime('now') returns 'YYYY-MM-DD HH:MM:SS' with no timezone marker. JS was treating this as local time, so timestamps showed the correct UTC digits but with the local TZ abbreviation attached (e.g. '7:15 PM EDT' when the real local time was '3:15 PM EDT'). Add parseUtc() which appends 'Z' before parsing any string that has no existing timezone marker, ensuring JS always treats them as UTC before the display-timezone conversion is applied. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
josh added 1 commit 2026-03-28 15:19:59 -04:00
fix: parse SQLite timestamps as UTC, not local time
CI / build-dev (pull_request) Has been skipped
Details
CI / test (pull_request) Successful in 14s
Details
e3911157e9 
SQLite datetime('now') returns 'YYYY-MM-DD HH:MM:SS' with no timezone
marker. JS was treating this as local time, so timestamps showed the
correct UTC digits but with the local TZ abbreviation attached (e.g.
'7:15 PM EDT' when the real local time was '3:15 PM EDT').

Add parseUtc() which appends 'Z' before parsing any string that has no
existing timezone marker, ensuring JS always treats them as UTC before
the display-timezone conversion is applied.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
josh scheduled this pull request to auto merge when all checks succeed 2026-03-28 15:20:03 -04:00
josh merged commit 9f6b2ece52 into dev 2026-03-28 15:20:15 -04:00
josh deleted branch fix/sqlite-utc-timestamps 2026-03-28 15:20:15 -04:00
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
josh (Josh Wright)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: josh/Catalyst#30