10 lines
460 B
SQL
10 lines
460 B
SQL
-- 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);
|