Re: Convert date and time colums to datetime

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Convert date and time colums to datetime
Date: 2025-10-20 12:51:19
Message-ID: 7e67aa96-1012-1d2a-6980-1569aab7839d@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2025-10-20 12:53:08 Re: Convert date and time colums to datetime
Previous Message Rich Shepard 2025-10-20 12:45:34 Re: Convert date and time colums to datetime