Re: Convert date and time colums to datetime

Rob Sargent <robjsargent@gmail.com>

From: Rob Sargent <robjsargent@gmail.com>

To: Rich Shepard <rshepard@appl-ecosys.com>

Cc: pgsql-general@postgresql.org

Date: 2025-10-20T12:53:08Z

Lists: pgsql-general

> On Oct 20, 2025, at 6:45 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> 
> On Sun, 19 Oct 2025, Rob Sargent wrote:
> 
>> Definitely a datetime (single value) problem, imho
> 
> Rob,
> 
> Okay. Now I'm curious: why do you write this?
> 
> Thanks,
> 
> Rich
> 

The way I read your description of how you use these columns currently suggests to me that they could be handled by a single timestamp column. The cost/benefit of converting is another thing altogether. 

>