Re: Convert date and time colums to datetime

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Convert date and time colums to datetime
Date: 2025-10-19 19:08:19
Message-ID: a72e49a3-d057-7cf9-f21f-983c84824e64@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2025-10-19 19:40:59 Re: Convert date and time colums to datetime
Previous Message Laurenz Albe 2025-10-19 18:09:23 Re: Convert date and time colums to datetime