Insertion syntax for interval data type in postgres

Question

I created a table with following the fields and I have used a interval field to store duration of the courses. I want to insert interval time in DD:HH and couldn't find the syntax for it.

Anybody can help me with this insertion syntax with above format DD:HH . Thanks in advance.

CREATE TABLE practical.course
(
  course_id character(3) primary key,
  course_name character varying(30),
  duration interval,
  dept_id integer references practical.department(dept_id)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE practical.course
  OWNER TO postgres;

Additionally consider the make_interval function (introduced in the 9.4 version) — Abelisto
– Abelisto, Commented Aug 3, 2016 at 17:52

Sidath Bhanuka Randeniya · Accepted Answer · 2016-08-03 17:56:18Z

5

You can insert as follows..

insert into practical.course(course_id,course_name, duration, dept_id)
values('104','Mathematical Engineering','40:00:00',1);

If you want to add days you can add 'no_of_days 40:00:00' instead '40:00:00'. You can insert in different formats and they are available in above link on the comment.

answered Aug 3, 2016 at 17:56

Sidath Bhanuka Randeniya

3523 gold badges5 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insertion syntax for interval data type in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related