"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
