PostgreSQL: Convert timestamp to time – or retrieve only time from timestamp column

select timestamp '2014-04-03 12:34:00'::time

I prefer ANSI date/timestamp literals as they are shorter to write than to_timestamp()

The above is equivalent to:

select to_timestamp ('03.04.2014 12:34:00', 'DD.MM.YYYY HH24:MI:SS')::time

the ::time is Postgres’ short hand notation for casting a value.

The following would be complete ANSI SQL if you want that:

select cast(timestamp '2014-04-03 12:34:00' as time)