Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAXe5-002qGE-Nv for pgsql-general@arkaria.postgresql.org; Sun, 19 Oct 2025 17:56:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAXe3-00BgeG-0l for pgsql-general@arkaria.postgresql.org; Sun, 19 Oct 2025 17:56:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vAXe2-00Bge8-MF for pgsql-general@lists.postgresql.org; Sun, 19 Oct 2025 17:56:37 +0000 Received: from mail.appl-ecosys.com ([50.126.108.78]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1vAXe0-002eML-03 for pgsql-general@postgresql.org; Sun, 19 Oct 2025 17:56:36 +0000 Received: from salmo.appl-ecosys.com (salmo.appl-ecosys.com [192.168.55.1]) by mail.appl-ecosys.com (Postfix) with ESMTP id C9CA82A14D6 for ; Sun, 19 Oct 2025 10:56:34 -0700 (PDT) Date: Sun, 19 Oct 2025 10:56:34 -0700 (PDT) From: Rich Shepard To: pgsql-general@postgresql.org Subject: Re: Convert date and time colums to datetime In-Reply-To: Message-ID: References: <63dfbc7c-bc63-7fa-a51b-915dd804ea2@appl-ecosys.com> <6b30ebac-6d6d-4c26-be73-de67e208e4e1@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 19 Oct 2025, Isaac Morland wrote: > If you're talking about actually changing the table, replacing the two > columns with a single column, you would need ALTER TABLE. Something like > (not tested, just to give you the basic idea): Issac, I thought it could be that simple, while I was looking in the date/time conditions/functions. Thanks, Rich