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