Convert date and time colums to datetime

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Convert date and time colums to datetime
Date: 2025-10-19 14:43:36
Message-ID: 63dfbc7c-bc63-7fa-a51b-915dd804ea2@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-10-19 14:53:56 Re: Convert date and time colums to datetime
Previous Message Nathan Bossart 2025-10-17 16:56:04 Re: Clarification on Role Access Rights to Table Indexes