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 5EB49A7A-AD45-4C6B-8275-8414D5817C40@gmail.com
Whole thread Raw
In response to Re: Convert date and time colums to datetime  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general

> On Oct 20, 2025, at 6:58 AM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
>
> On Mon, 20 Oct 2025, Rob Sargent wrote:
>
>>> Okay. Now I'm curious: why do you write this?
>
>> 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.
>
> Rob,
>
> Since either way works I'll save the time cost of converting because my
> tables will never be really large.
>
> Thanks,
>
> Rich
>

For sure! Your call
>



pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Convert date and time colums to datetime
Next
From: Michał Kłeczek
Date:
Subject: Re: Arrays vs separate tables