If the input table has separate date and
time columns, you can create a single timestamp column.
-
Use this query:
SELECT (datecolumn || ' ' || timecolumn)::timestamp AS mytimestamp FROM input_table;