Bohan Jiang
5900d8b637
fix(issues): make start_date/due_date timezone-stable calendar days ( #3618 ) ( #3692 )
...
* fix(issues): store start_date/due_date as DATE, not timestamp (MUL-2925)
These fields are calendar days (the pickers offer no time-of-day), but were
stored as TIMESTAMPTZ. A client serializing local midnight via toISOString()
folded its timezone into the instant, so the day shifted by the local offset
(GH #3618 ). Migrate the columns to DATE and parse/serialize date-only
"YYYY-MM-DD". ParseCalendarDate still accepts legacy RFC3339 (truncated to the
UTC day) so older clients keep working.
Co-authored-by: multica-agent <github@multica.ai >
* fix(issues): render start_date/due_date as timezone-stable calendar days (MUL-2925)
Pickers now emit date-only "YYYY-MM-DD" (local calendar day) instead of
toISOString(), and every read formats via the shared @multica/core/issues/date
helpers with timeZone:"UTC" so the day never shifts with the viewer's offset.
The Gantt's existing UTC bucketing is now correct. Covers web/desktop pickers,
quick-set menu, list/board/detail/activity, and the mobile due-date picker.
Co-authored-by: multica-agent <github@multica.ai >
* fix(issues): address date-only review — loud-fail ambiguous dates, finish display sweep (MUL-2925)
Review follow-ups on #3692 :
- ParseCalendarDate no longer silently truncates a legacy non-midnight RFC3339
to the wrong UTC day; it accepts only YYYY-MM-DD or an exact UTC-midnight
instant and rejects ambiguous ones loudly. Adds util unit tests.
- migration 112 pins the TIMESTAMPTZ->DATE conversion to UTC explicitly via
AT TIME ZONE 'UTC' (was session-timezone dependent); down migration too.
- Convert remaining date-change display sites to formatDateOnly: inbox detail
label (web) and mobile activity + inbox labels (were new Date()+local format).
- CLI --start-date/--due-date help now says YYYY-MM-DD, not RFC3339.
Co-authored-by: multica-agent <github@multica.ai >
---------
Co-authored-by: J <j@multica.ai >
Co-authored-by: multica-agent <github@multica.ai >
2026-06-03 14:34:01 +08:00
..
2026-03-26 17:17:23 +08:00
2026-03-26 18:28:36 +08:00
2026-03-26 18:28:36 +08:00
2026-03-27 15:49:30 +08:00
2026-03-27 15:49:30 +08:00
2026-03-28 19:33:20 +08:00
2026-03-28 19:33:20 +08:00
2026-03-28 19:33:20 +08:00
2026-03-28 20:24:07 +08:00
2026-03-28 21:53:08 +08:00
2026-03-28 21:53:08 +08:00
2026-03-28 22:04:35 +08:00
2026-03-28 22:04:35 +08:00
2026-03-29 00:22:17 +08:00
2026-03-29 00:22:17 +08:00
2026-03-29 16:49:55 +08:00
2026-03-29 16:49:55 +08:00
2026-03-29 16:53:28 +08:00
2026-03-29 16:53:28 +08:00
2026-03-29 17:01:07 +08:00
2026-03-29 17:01:07 +08:00
2026-03-29 17:52:35 +08:00
2026-03-29 17:52:35 +08:00
2026-03-30 03:08:52 +08:00
2026-03-30 03:08:52 +08:00
2026-03-30 13:26:42 +08:00
2026-03-30 13:26:42 +08:00
2026-03-30 16:49:13 +08:00
2026-03-30 16:49:13 +08:00
2026-03-30 22:37:59 +08:00
2026-03-30 22:37:59 +08:00
2026-03-30 22:53:28 +08:00
2026-03-30 22:53:28 +08:00
2026-03-30 22:37:59 +08:00
2026-03-30 22:37:59 +08:00
2026-03-31 13:48:39 +08:00
2026-03-31 13:48:39 +08:00
2026-03-31 15:29:41 +08:00
2026-03-31 15:29:41 +08:00
2026-03-31 16:19:02 +08:00
2026-03-31 16:19:02 +08:00
2026-03-31 16:13:58 +08:00
2026-03-31 16:13:58 +08:00
2026-03-31 15:47:09 +08:00
2026-03-31 15:47:09 +08:00
2026-04-02 17:33:52 +08:00
2026-04-02 17:33:52 +08:00
2026-04-07 22:02:28 +08:00
2026-04-07 22:02:28 +08:00
2026-04-09 12:43:21 +08:00
2026-04-09 14:00:03 +08:00
2026-04-09 13:38:46 +08:00
2026-04-09 13:38:46 +08:00
2026-04-08 13:08:15 +08:00
2026-04-08 13:08:15 +08:00
2026-04-09 14:19:46 +08:00
2026-04-09 17:18:14 +08:00
2026-04-09 12:43:21 +08:00
2026-04-09 14:00:03 +08:00
2026-04-09 14:59:16 +08:00
2026-04-09 14:59:16 +08:00
2026-04-09 16:31:05 +08:00
2026-04-09 16:31:05 +08:00
2026-04-10 14:34:32 +08:00
2026-04-10 14:34:32 +08:00
2026-04-10 14:29:00 +08:00
2026-04-10 14:29:00 +08:00
2026-04-10 16:21:20 +08:00
2026-04-10 16:21:20 +08:00
2026-04-10 19:00:25 +08:00
2026-04-10 19:00:25 +08:00
2026-04-10 20:59:32 +08:00
2026-04-10 20:59:32 +08:00
2026-04-13 16:47:56 +08:00
2026-04-13 16:47:56 +08:00
2026-04-14 18:21:11 +08:00
2026-04-14 18:21:11 +08:00
2026-04-15 14:58:53 +08:00
2026-04-15 14:58:53 +08:00
2026-04-15 00:01:18 +08:00
2026-04-15 00:01:18 +08:00
2026-04-15 04:54:37 +08:00
2026-04-15 04:54:37 +08:00
2026-04-16 13:16:35 +08:00
2026-04-16 13:16:35 +08:00
2026-04-15 13:48:21 +08:00
2026-04-15 13:48:21 +08:00
2026-04-16 13:16:35 +08:00
2026-04-16 13:16:35 +08:00
2026-04-16 13:16:35 +08:00
2026-04-16 13:16:35 +08:00
2026-04-18 01:35:22 +08:00
2026-04-18 01:35:22 +08:00
2026-04-17 13:40:02 +08:00
2026-04-17 13:40:02 +08:00
2026-04-16 18:54:12 +08:00
2026-04-16 18:54:12 +08:00
2026-04-16 21:21:20 +08:00
2026-04-16 21:21:20 +08:00
2026-04-17 15:10:38 +08:00
2026-04-17 15:10:38 +08:00
2026-04-19 23:21:31 -07:00
2026-04-19 23:21:31 -07:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 00:06:34 +08:00
2026-04-21 00:06:34 +08:00
2026-04-21 14:42:52 +08:00
2026-04-21 14:42:52 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-21 20:32:33 +08:00
2026-04-22 13:08:37 +08:00
2026-04-22 13:08:37 +08:00
2026-04-22 15:08:06 +08:00
2026-04-22 15:08:06 +08:00
2026-04-23 10:35:55 +08:00
2026-04-23 10:35:55 +08:00
2026-04-24 11:05:33 +08:00
2026-04-24 11:05:33 +08:00
2026-04-27 14:23:42 +08:00
2026-04-27 14:23:42 +08:00
2026-05-06 16:16:12 +08:00
2026-05-06 16:16:12 +08:00
2026-04-29 14:50:58 +08:00
2026-04-29 14:50:58 +08:00
2026-05-03 10:51:31 +08:00
2026-05-03 10:51:31 +08:00
2026-04-29 14:05:26 +08:00
2026-04-29 14:05:26 +08:00
2026-04-29 14:50:58 +08:00
2026-04-29 14:50:58 +08:00
2026-04-29 18:29:46 +08:00
2026-04-29 18:29:46 +08:00
2026-04-29 18:29:46 +08:00
2026-04-29 18:29:46 +08:00
2026-04-29 22:51:29 +02:00
2026-04-29 22:51:29 +02:00
2026-04-30 16:05:53 +08:00
2026-04-30 16:05:53 +08:00
2026-04-30 14:00:43 +08:00
2026-04-30 14:00:43 +08:00
2026-04-30 14:17:53 +08:00
2026-04-30 14:17:53 +08:00
2026-04-30 15:50:05 +08:00
2026-04-30 15:50:05 +08:00
2026-05-06 16:27:06 +08:00
2026-05-06 16:27:06 +08:00
2026-05-09 05:49:33 +02:00
2026-05-09 05:49:33 +02:00
2026-05-07 15:45:29 +08:00
2026-05-07 15:45:29 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-08 15:35:21 +08:00
2026-05-09 15:07:57 +08:00
2026-05-09 15:07:57 +08:00
2026-05-09 14:39:10 +08:00
2026-05-09 14:39:10 +08:00
2026-05-12 13:49:03 +08:00
2026-05-12 13:49:03 +08:00
2026-05-09 15:07:57 +08:00
2026-05-09 15:07:57 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-11 14:39:35 +08:00
2026-05-12 10:57:54 +08:00
2026-05-12 10:57:54 +08:00
2026-05-11 22:53:07 +08:00
2026-05-11 22:53:07 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 12:51:16 +08:00
2026-05-13 12:51:16 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-13 18:46:20 +08:00
2026-05-14 14:07:26 +08:00
2026-05-14 14:07:26 +08:00
2026-05-14 15:23:36 +02:00
2026-05-14 15:23:36 +02:00
2026-05-18 12:17:39 +08:00
2026-05-18 12:17:39 +08:00
2026-05-17 15:01:38 +08:00
2026-05-17 15:01:38 +08:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-16 21:26:30 +02:00
2026-05-18 14:59:40 +08:00
2026-05-18 14:59:40 +08:00
2026-05-19 05:35:18 +02:00
2026-05-19 05:35:18 +02:00
2026-05-20 12:30:10 +08:00
2026-05-20 12:30:10 +08:00
2026-05-19 18:37:48 +02:00
2026-05-19 18:37:48 +02:00
2026-05-20 05:30:13 +02:00
2026-05-20 05:30:13 +02:00
2026-05-19 19:51:28 +02:00
2026-05-19 19:51:28 +02:00
2026-05-20 15:37:23 +08:00
2026-05-20 15:37:23 +08:00
2026-05-22 13:22:36 +08:00
2026-05-22 13:22:36 +08:00
2026-05-21 19:00:26 +08:00
2026-05-21 19:00:26 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 16:26:42 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 15:33:47 +08:00
2026-05-21 16:35:45 +08:00
2026-05-21 16:35:45 +08:00
2026-05-22 12:26:56 +08:00
2026-05-22 12:26:56 +08:00
2026-05-22 14:51:43 +08:00
2026-05-22 14:51:43 +08:00
2026-05-25 18:42:48 +08:00
2026-05-25 18:42:48 +08:00
2026-05-27 13:44:31 +08:00
2026-05-27 13:44:31 +08:00
2026-05-26 17:00:01 +08:00
2026-05-26 17:00:01 +08:00
2026-05-26 16:45:46 +08:00
2026-05-26 16:45:46 +08:00
2026-05-27 15:47:36 +08:00
2026-05-27 15:47:36 +08:00
2026-06-01 16:48:05 +02:00
2026-06-01 16:48:05 +02:00
2026-06-03 14:34:01 +08:00
2026-06-03 14:34:01 +08:00