Request a Demo
Home   >   mailing lists

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

From Ron Johnson
Subject Re: Convert date and time colums to datetime
Date
Msg-id CANzqJaBeBHenwbUjKyp4+9TAXgFaKnV4U4ef88ezPhs5P10w-g@mail.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
Tree view
On Mon, Oct 20, 2025 at 8: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.
 
Virtual columns exist: have both!

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Convert date and time colums to datetime
Next
From: Rob Sargent
Date:
Subject: Re: Convert date and time colums to datetime