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 1vApO9-006N2X-4e for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 12:53:24 +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 1vApO8-0001nk-4P for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 12:53:23 +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 1vApO7-0001na-Pm for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 12:53:22 +0000 Received: from mail-pl1-x62a.google.com ([2607:f8b0:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vApO5-002mx4-0x for pgsql-general@postgresql.org; Mon, 20 Oct 2025 12:53:21 +0000 Received: by mail-pl1-x62a.google.com with SMTP id d9443c01a7336-290d4d421f6so29441885ad.2 for ; Mon, 20 Oct 2025 05:53:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760964800; x=1761569600; darn=postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=XHm+sPlV6G7ZV4H8HNEDWFCPeb2gGNpyD0dFdwsr7rM=; b=FoW2njvkCj602Y38I6YKiokG1ko+8wvLzRaMPNeTq0u9TgvkrOvTFXqUMpq82HoOdu pD1Hty4lMwr8CoGVWaY+v3h9V8aEBK09olr0uJkeqJEtjz3puOFhrRsmLiTd+VcQiSLd 3nnYSTd3KphJji60AgPcXV/bxcDfLZPCzR7gpOSpoiQAdwiDmK9oUPEjdfX02oeI+5Ty B8AO1v2loQD8LLl0NqAtDj9xqHCORe/8hdv3rOb3ybOMk1mNQ0QovAj449hyPc+dmOSL NjTnvkd3EySvQoIbDhe4qDn+iVTWVgrAgaCHeR0N0SgREjRFjR5WdnikK9uwTAEiiYcv iQww== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760964800; x=1761569600; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=XHm+sPlV6G7ZV4H8HNEDWFCPeb2gGNpyD0dFdwsr7rM=; b=phocqS+g6Iz0+cOWnlbtBetBAQrWfsJzfnr/q4ocjykKwgWIj/fIAqiKGgH8SDBXrZ bj4Uaub/6imXUvrLzNQ0+qekNgyRraKYhPjnIfNbHUvlfO30OE3/qT/zmm3sFd6B1pLe vcgzboZwD4FPkyWEaqTpanGcBatIiCRGTcl2xNxQbAO+r+51JvK64ik6Qf6x5dQ06Ja8 Mx6KaFO4Et/wa+HlAm2s/dvI01q4AWVL1U1289KXgjUCENTAfGsLQWgty/zWs5rZamv7 Wq2zSNg2N5uc5/McRGcKV9jvjjgKdXqs54kw8bc5UB/DijZP3NXjGkhsjcE52IE4krIB fLTg== X-Gm-Message-State: AOJu0YyCIrb8wMj4eZR028syHiUqOxfzZHq2PS3UlVYc56rwcC0Kx+fC XprGyG5WJOlPDXh0tH84B+SuXmSFkKgMeAj2X9YnD08G+TOc2g8CnyRx6Q8nYbm6 X-Gm-Gg: ASbGncsv2U0Ub1wbc8LJ8Hrk8DllLuexmPnXY7b180ywYzbQKy6fpzBI1avgomatX68 UfX0aqLnaJvXxjwkXSC6E7YCxwiAik4KVE747CvCnrX6UPpCBB/ztjByIXmDXV0lFJmySEwR7uK pYzFGXjqEPsYIq6t0p8imtpBaBnBbCb9dnQ5uG/PNWP3NpRq44g9ALpuQHcxeRe0Lh4WMjuUOHQ 7mgGzu/YJdZIY47ZUGowni6hugaCZKKahbza0L1Ap14Ycm/E4Z8phskO0CNm/4bXY6Y9gIF6i+m SGK7EWuDpxo+C39On2kMBxiz8O0osV+DUBL93sHAYTB/10w4Y7Cy1TTv/pg9idBaKzCLFH9D0gx ztlphtMFcmmPRB5fSclhTecn6lnOyM1EZlCXCybgabEL32tKbh7IP0a6MCXVzCHj2wFTuCqpyOa wnbDRtkwp/SADMTD68 X-Google-Smtp-Source: AGHT+IHlwWz/Rne1ZU/qmk9russgw0VUQyGWy9lT9XhgcjHezmDWk0nD09pCG2HZCKxRKnkTFC16CA== X-Received: by 2002:a17:902:d501:b0:28e:7fce:667e with SMTP id d9443c01a7336-290c9cbc6d2mr169384125ad.17.1760964800194; Mon, 20 Oct 2025 05:53:20 -0700 (PDT) Received: from smtpclient.apple ([15.220.16.55]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-29247218eafsm79225385ad.101.2025.10.20.05.53.19 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 Oct 2025 05:53:19 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: Convert date and time colums to datetime Date: Mon, 20 Oct 2025 06:53:08 -0600 Message-Id: <769142BB-E2E0-4943-A8FB-A9F8FB7B4932@gmail.com> References: <2d6e71ef-dbd0-a9c8-b819-c8b97b630c8@appl-ecosys.com> Cc: pgsql-general@postgresql.org In-Reply-To: <2d6e71ef-dbd0-a9c8-b819-c8b97b630c8@appl-ecosys.com> To: Rich Shepard X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Oct 20, 2025, at 6:45=E2=80=AFAM, Rich Shepard wrote: >=20 > =EF=BB=BFOn Sun, 19 Oct 2025, Rob Sargent wrote: >=20 >> Definitely a datetime (single value) problem, imho >=20 > Rob, >=20 > Okay. Now I'm curious: why do you write this? >=20 > Thanks, >=20 > Rich >=20 The way I read your description of how you use these columns currently sugge= sts to me that they could be handled by a single timestamp column. The cost/= benefit of converting is another thing altogether.=20 >=20