Postgres TIMESTAMP query

Question

I'm using copy to import a csv file into postgres, one of the fields contains a time value in HH:MM:SS formate. I want to be able to set this to a TIMESTAMP field, I've looked through lots of documents but I'm struggling to work out what field type to set it to. I see lots of reference to creating fields with timezones or not, a date etc, not really what I'm after. The ultimate aim is to create reports based on time intervals, e.g. all data between 00:00:00 and 06:30:00 etc

Eelke · Accepted Answer · 2012-12-22 08:31:34Z

5

A timestamp in postgres is date and a time combined. For times only use the type time or time with time zone.

answered Dec 22, 2012 at 8:31

Eelke

22.3k5 gold badges57 silver badges77 bronze badges

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

Comments

Houari · Accepted Answer · 2012-12-22 10:24:07Z

0

Here is an example:

CREATE TABLE table01
(
  rowid bigint NOT NULL,
  time_field time without time zone,
  CONSTRAINT table01_pkey PRIMARY KEY (rowid)
)
WITH (
  OIDS=FALSE
);

And here is an file example:

100,12:30:59
200,08:59:01

You can importe this last file to table01 using copy command like this:

COPY table01 from 'c:/tmp/table01.txt' with csv

Considerning that the file named table01.txt located at : c:/tmp/ folder.

Reference: copy

answered Dec 22, 2012 at 10:24

Houari

5,6513 gold badges33 silver badges57 bronze badges

Collectives™ on Stack Overflow

Postgres TIMESTAMP query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related