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