Request a Demo
Home   >   mailing lists

Re: Convert date and time colums to datetime - Mailing list pgsql-general

From Rich Shepard
Subject Re: Convert date and time colums to datetime
Date
Msg-id 7e67aa96-1012-1d2a-6980-1569aab7839d@appl-ecosys.com
Whole thread Raw
In response to Re: Convert date and time colums to datetime  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Convert date and time colums to datetime
Next
From: Rob Sargent
Date:
Subject: Re: Convert date and time colums to datetime