Request a Demo
Home   >   mailing lists

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

From Rob Sargent
Subject Re: Convert date and time colums to datetime
Date
Msg-id 769142BB-E2E0-4943-A8FB-A9F8FB7B4932@gmail.com
Whole thread Raw
In response to Re: Convert date and time colums to datetime  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Convert date and time colums to datetime
List pgsql-general
Tree view 

> 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
singletimestamp column. The cost/benefit of converting is another thing altogether.  

>

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Convert date and time colums to datetime
Next
From: Rich Shepard
Date:
Subject: Re: Arrays vs separate tables