Reason: Error occurred during query execution:
ConnectorError(ConnectorError { user_facing_error: None, kind: QueryError(Error { kind: FromSql(1), cause: Some(WrongType { postgres: Type(Date), rust: "core::option::Option<alloc::string::String>" }) }) })
generated model
model account {
avatarpath String
birthday DateTime
email String
emailisvalid Boolean @default(false)
gender Boolean
id Int @id
lastactiveip String
lastactivetime DateTime
mobile String
mobileisvalid Boolean @default(false)
password String
qq String
realname String
regip String
regtime DateTime
roleid Int
username String
wx String
}
table sql
-- DROP TABLE public.account;
CREATE TABLE public.account
(
id integer NOT NULL DEFAULT nextval('account_id_seq'::regclass),
username character varying(64) COLLATE pg_catalog."default" NOT NULL,
password character varying(64) COLLATE pg_catalog."default" NOT NULL,
email character varying(140) COLLATE pg_catalog."default" NOT NULL,
mobile character varying(140) COLLATE pg_catalog."default" NOT NULL,
gender boolean NOT NULL,
birthday date NOT NULL,
roleid integer NOT NULL DEFAULT (10)::smallint,
avatarpath character varying(20) COLLATE pg_catalog."default" NOT NULL,
regtime timestamp without time zone NOT NULL,
regip character varying(15) COLLATE pg_catalog."default" NOT NULL,
lastactivetime timestamp without time zone NOT NULL,
lastactiveip character varying(15) COLLATE pg_catalog."default" NOT NULL,
qq character varying(140) COLLATE pg_catalog."default" NOT NULL,
wx character varying(140) COLLATE pg_catalog."default" NOT NULL,
realname character varying(50) COLLATE pg_catalog."default" NOT NULL,
mobileisvalid boolean NOT NULL DEFAULT false,
emailisvalid boolean NOT NULL DEFAULT false,
CONSTRAINT account_pkey PRIMARY KEY (id)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;
ALTER TABLE public.account
OWNER to postgres;
const { PrismaClient } = require('@prisma/client')
const prisma = new PrismaClient()
async function main() {
const account = await prisma.account.findOne({ where: { id: 1 } })
console.log(account)
}
main()
I changed birthday type to timestamp without time zone, it works.
node.js code
column birthday error occurred
I changed birthday type to timestamp without time zone, it works.