SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE "prodstageagenda" ( "sta_id" int NOT NULL GENERATED BY DEFAULT AS IDENTITY, "startdate" timestamptz NOT NULL, "enddate" timestamptz NOT NULL, CONSTRAINT "PK_prodstageagenda" PRIMARY KEY ("sta_id") ); insert into prodstageagenda (startdate, enddate) values ('2022-05-01 12:13:14', '2022-05-04 14:13:14' ); CREATE OR REPLACE VIEW prodstageagenda_view AS SELECT "a"."startdate" AS "startdate", "a"."enddate" AS "enddate", ("a"."enddate" - "a"."startdate"), (date_part('minute', "a"."enddate" - "a"."startdate") / 60) AS "hours" FROM "prodstageagenda" "a"; select * from prodstageagenda_view;
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear