josh/Catalyst
1
0
Fork 0
Code Issues 3 Pull Requests Actions Packages Projects Releases 13 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

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
All checks were successful
CI / test (pull_request) Successful in 14s
Details
CI / build-dev (pull_request) Has been skipped
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 Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
josh
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: josh/Catalyst#30
Delete Branch "fix/sqlite-utc-timestamps"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?