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 1vApuV-006R7q-DR for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 13:26:50 +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 1vApuR-000KRh-MC for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 13:26:46 +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 1vApuR-000KRX-BK for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 13:26:46 +0000 Received: from mail-pj1-x102b.google.com ([2607:f8b0:4864:20::102b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vApuO-002nKj-2b for pgsql-general@postgresql.org; Mon, 20 Oct 2025 13:26:45 +0000 Received: by mail-pj1-x102b.google.com with SMTP id 98e67ed59e1d1-33bcf228ee4so3050707a91.1 for ; Mon, 20 Oct 2025 06:26:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760966804; x=1761571604; 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=+wGyj4L3YU4itT51mbzJM8S6GLvTRY2Q4/DXA35k34A=; b=CSfeceW8XbS/Tkbe83UfHt479B8ubNDMX8+icX9uu549x6Yi2lkDONGqHYnuhYCLw/ B06gRW0DZrFnWFmOeFwCO20TzHLMQGHIwqdXFMX8fULo7y26xRM14Dq0WIs/yy6D031s qRptl/gVwUqd2br7EEEmUJMDFrlEV99eRg+D40fsErHh5iwnjBPDa6qlF8XxmQPRGMAF zHKVbMQIFgprt286LF6dfI4lHqPe0UcZi7Ic5ZMAkFX4ThP7XNBqSvTWj02C376kqlBm XjKDR0I+BYVmvr1kuuJADLG/3LvCJ3FrZGtXzJseOSnq9NOQy7iW0IS9cELgw2h3iqI/ 3pfg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760966804; x=1761571604; 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=+wGyj4L3YU4itT51mbzJM8S6GLvTRY2Q4/DXA35k34A=; b=sMtZpHhG6C7bz9C3CclZ2jBeaXGXfIZR2h0UxKxGTiXLSGhPOptLaJS4c1BxESd/JA OXkaVtZToJsADwHZFKGJNNlLNef1em8LRtSp8P83U73KtMesFdt8HJ7ozQ80fyYT/hGS uZqH3b5tgkD7hXTQbWMCqRIdxG6SKoCNST3i8NDsIcO9EURvWtufrWkEAUq1Dx+53XYW ys0eletKR01y+MpSUe5F9GCcFrKNysRtwkL+qNle26UpTHbj/+3kNH9alQF2oB5/8tRq xNiK/GAiZVs27vhXBq54+SLs8yA9QokVoxGJ+J3esrISwW162w9CphVUE9cGDqubDsFS 4OAQ== X-Gm-Message-State: AOJu0YxdJ/zD3YmtzTRfMk0Cv4frtez/fYXASY0o6pwBc4mdlYpqZ546 U3VhFJjZRG1qfoMyI5Px2WAml1z4pJU4JGRRlB3jRDXAYXIBh2nHWYdz X-Gm-Gg: ASbGncsINxfpZgChibnBRmXttTT8S7SHZQ5mC22WdeFKouX5gx2ba7RK0SP4drPNaig Jmqp6cE57GPlWMueZBDItej0UR2tuv/HG+BnRcsJPinfb70G6lOw26y8OCPTxDagHDsXEqvFrwI 2EnNSJtz8RBce/kIYF6zEdap6cMrLw9/CHH71MbHq2CUecB+y4ffBfyiB8NyJ1xLGtROOClLDHy HNk19aEGe915LPXPoUD/HIqCQs26K5n5ZlCp4HYFBLnh+XgTq42ZRmCgCFZPsRcxKyXuqi93Zss F292fGc6eev+lN2hFE/HPr8/uIluglq2dEVVTPr+BtabthLbAvyiQckN/y97XN2eeUVcrRnsiXm i+KO/xUTMRIdsUlJnrMoC0i0XLXRpaksMhVdq4TGIEcOILGMgKfUT3Jbolv3bG1XvK0Qd3u1UOV YFRtgcf2BDotTkinGS X-Google-Smtp-Source: AGHT+IG3f+tuKAnfdRkcZ4I9Rmht8EC/4si0li8Rz3BpCK2aqYzCLspehA4kL4aFLhPlpYfsVs0Mhw== X-Received: by 2002:a17:90b:1dc6:b0:339:a4ef:c8b1 with SMTP id 98e67ed59e1d1-33bcf8f7802mr17218434a91.22.1760966803721; Mon, 20 Oct 2025 06:26:43 -0700 (PDT) Received: from smtpclient.apple ([15.220.16.55]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b6a764508b0sm7751522a12.0.2025.10.20.06.26.43 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 Oct 2025 06:26:43 -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 07:26:32 -0600 Message-Id: <5EB49A7A-AD45-4C6B-8275-8414D5817C40@gmail.com> References: <8ed458fc-e661-8823-d394-75af4b7fd9e@appl-ecosys.com> Cc: pgsql-general@postgresql.org In-Reply-To: <8ed458fc-e661-8823-d394-75af4b7fd9e@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:58=E2=80=AFAM, Rich Shepard wrote: >=20 > =EF=BB=BFOn Mon, 20 Oct 2025, Rob Sargent wrote: >=20 >>> Okay. Now I'm curious: why do you write this? >=20 >> The way I read your description of how you use these columns currently >> suggests to me that they could be handled by a single timestamp column. >> The cost/benefit of converting is another thing altogether. >=20 > Rob, >=20 > Since either way works I'll save the time cost of converting because my > tables will never be really large. >=20 > Thanks, >=20 > Rich >=20 For sure! Your call >=20