extract date and time from timestamp column on postgresql

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