Prisma is not including columns of Postgres type 'time without time zone' in schema

[yim77]

Unfortunately Prisma is not including columns of Postgres type 'time without time zone' in schema. These columns are simply missing in schema.

SQL DB Script:

CREATE TABLE public.oeffnungszeiten
(
    id integer NOT NULL DEFAULT nextval('oeffnungszeiten_id_seq'::regclass),
    res_id integer NOT NULL,
    wt integer NOT NULL,
    slot1_von time without time zone NOT NULL,
    slot1_bis time without time zone NOT NULL,
    slot2_von time without time zone,
    slot2_bis time without time zone,
    CONSTRAINT oeffnungszeiten_pkey PRIMARY KEY (id),
    CONSTRAINT fk_oeffnungszeiten_restaurant FOREIGN KEY (res_id)
        REFERENCES public.restaurant (id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.oeffnungszeiten
    OWNER to postgres;

-- Index: fki_fk_oeffnungszeiten_restaurant

-- DROP INDEX public.fki_fk_oeffnungszeiten_restaurant;

CREATE INDEX fki_fk_oeffnungszeiten_restaurant
    ON public.oeffnungszeiten USING btree
    (res_id)
    TABLESPACE pg_default;

Generated Schema:

model Oeffnungszeiten {
  id  Int        @id
  res Restaurant @map("res_id")
  wt  Int

  @@map("oeffnungszeiten")
}

How should I include this columns?

[pantharshit00]

I can confirm this.

[johannesschobel]

that is most likely, because Prisma2 does not have support for DateTime With Timezones. The DateTime Without Timezone is mapped to DateTime type.

I am in desperate need of Timezone Support as well :(

[AhmedElywa]

I am in desperate need of Timezone Support as well

Me too any update in this

[janpio]

Just to clarify: Do I understand correctly that you ran prisma2 introspect on your database @yim77 and the time without time zone columns were not represented in the created schema.prisma?

[pantharshit00]

@janpio They are straight missing from the schema

[janpio]

Related: #1104

[do4gr]

I just tested this and they are now in the schema as DateTime. We will still need a more fine grained mapping than just DateTime to represent the different Time/Date types but that is a different issue. I am therefore closing this.