Horton
Menu

Re: 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@lists.postgresql.org
Date: 2025-10-20T12:51:19Z
Lists: pgsql-general 
On Mon, 20 Oct 2025, Rob Sargent wrote:

> I don’t see any mention of the current data types of the two columns
> currently in play. apologies of I missed that.

     Column    |          Type          | Collation | Nullable |         Default 
--------------+------------------------+-----------+----------+-----------------
  contact_date | date                   |           | not null | CURRENT_DATE
  contact_time | time without time zone |           |          |

Rich