Horton
Menu

Convert date and time colums to datetime

Rich Shepard <rshepard@appl-ecosys.com>

View thread
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2025-10-19T14:43:36Z
Lists: pgsql-general 
The database has a table with separate date and time columns.

1. Are there benefits to merging the two into a single timestamp column?

2. If so, how would I do this? (Reading date/time operators and functions
doc page hasn't shown me one.)

TIA,

Rich