When I execute this:
"insert into comments
(
date_posted
)

(select date_published
from xyz
)"

I get :
"ERROR: column "date_posted" is of type timestamp without time zone but
expression is of type text
HINT: You will need to rewrite or cast the expression."

Both dates are of type timesamp!
I searched how to cast, and can't find it.

What is the syntax to cast a timestamp to a timestamp?
tia,
..V

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend