Re: Convert date and time colums to datetime
Rich Shepard <rshepard@appl-ecosys.com>
From: Rich Shepard <rshepard@appl-ecosys.com>
To: pgsql-general@postgresql.org
Date: 2025-10-19T19:08:19Z
Lists: pgsql-general
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