Date: Sun, 19 Oct 2025 12:08:19 -0700 (PDT)
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Subject: Re: Convert date and time colums to datetime
In-Reply-To: <6c2fadf7fb9f5b0f1728b0baf9f112f3204415fe.camel@cybertec.at>
Message-ID: <a72e49a3-d057-7cf9-f21f-983c84824e64@appl-ecosys.com>
References: <63dfbc7c-bc63-7fa-a51b-915dd804ea2@appl-ecosys.com> <6c2fadf7fb9f5b0f1728b0baf9f112f3204415fe.camel@cybertec.at>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII; format=flowed
Archived-At: <https://www.postgresql.org/message-id/a72e49a3-d057-7cf9-f21f-983c84824e64%40appl-ecosys.com>
Precedence: bulk

On Sun, 19 Oct 2025, Laurenz Albe wrote:

> That depends on what you do with the table.

Laurenz,

That makes sense.

> Are your SQL statements simple and natural with the current design?
> Then stick with what you have now.

That's what I'm going to do. I was curious when a timestamp column was more
efficient, or otherwise preferred, since only a couple of my databases have
a table with both date and time. And neither has many rows, but one could be
quite large some time in the future.

Thanks very much,

Rich