to extract date from coldate,

SELECT date(coldate) FROM mytable;

to extract time, doing time(coldate) will give an error instead,

SELECT "time"(coldate) FROM mytable

another way

SELECT coldate::time FROM mytable


postgresql date/time doc

extract date from timestamp