Skip to content

TaskView is a self-hosted project and task management platform focused on clarity, ownership, and control. TaskView is built for teams that want a transparent, self-hosted alternative to SaaS task managers.

297 B
Raw Blame
-- Convert TIMETZ columns to TIME (without timezone)
-- Existing values are converted to UTC automatically by "AT TIME ZONE 'UTC'"
ALTER TABLE tasks.tasks
  ALTER COLUMN start_time TYPE TIME USING start_time AT TIME ZONE 'UTC',
  ALTER COLUMN end_time TYPE TIME USING end_time AT TIME ZONE 'UTC';