-- Change the type of start and end times to include data and timezone.
-- Drop the now obsolete date table
ALTER TABLE screenings
    ALTER COLUMN start_time TYPE timestamp with time zone
    USING date::TIMESTAMP + start_time,

    ALTER COLUMN end_time TYPE timestamp with time zone
    USING date::TIMESTAMP + end_time,

    DROP COLUMN date;