Re: Convert date and time colums to datetime

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Convert date and time colums to datetime
Date: 2025-10-20 13:26:32
Message-ID: 5EB49A7A-AD45-4C6B-8275-8414D5817C40@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Oct 20, 2025, at 6:58 AM, Rich Shepard <rshepard(at)appl-ecosys(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michał Kłeczek 2025-10-20 13:38:21 Re: Arrays vs separate tables
Previous Message Ron Johnson 2025-10-20 13:00:19 Re: Convert date and time colums to datetime