postgresql - Extract date and time into timestamp

Question

I have a table in PostgreSQL with columns new_date and new_time. I created a new column new_timestamp, now I need to extract date from new_date and time from new_time and insert into new_timestamp.

Thanks in advance.

Answer 1

As simple as:

UPDATE your_table
SET new_timestamp = new_date + new_time;