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 12:53:08
Message-ID: 769142BB-E2E0-4943-A8FB-A9F8FB7B4932@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2025-10-20 12:55:33 Re: Arrays vs separate tables
Previous Message Rich Shepard 2025-10-20 12:51:19 Re: Convert date and time colums to datetime