-- Convert leave start/end columns from DATE to TIMESTAMP(3)
-- so that HOURLY leaves can store the actual start/end time of day.
-- Without this, Postgres truncates the time and every hourly leave
-- renders at the company timezone offset (e.g. 03:00) instead of the
-- chosen time.

ALTER TABLE "leaves"
  ALTER COLUMN "startDate" TYPE TIMESTAMP(3) USING "startDate"::timestamp(3),
  ALTER COLUMN "endDate"   TYPE TIMESTAMP(3) USING "endDate"::timestamp(3);