Can't extract time from timestamp Postgres

Question

Hi im trying to extract time from a timestamp in Postgres

SELECT extract(time from '2000-01-01 01:12:00'::timestamp)

Result should be: 01:12:00

It looks like that time is not a valid argument for extract. Is that right?

Clodoaldo Neto · Accepted Answer · 2017-08-24 15:21:33Z

20

select '2000-01-01 01:12:00'::timestamp::time

answered Aug 24, 2017 at 15:21

Clodoaldo Neto

127k30 gold badges251 silver badges274 bronze badges

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

Comments

baduker · Accepted Answer · 2019-03-29 10:40:09Z

11

Try this:

s=# SELECT cast ('2000-01-01 01:12:00'::timestamp as time);
   time
----------
 01:12:00
(1 row)

doesn't extract - then, you might want to use cast.

time is not a valid aprt

baduker

20.2k9 gold badges43 silver badges63 bronze badges

answered Aug 24, 2017 at 15:20

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges