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 1vApV7-006NwB-ML for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 13:00:36 +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 1vApV6-000BU4-GX for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 13:00:35 +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 1vApV6-000BTt-5j for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 13:00:35 +0000 Received: from mail-oa1-x2e.google.com ([2001:4860:4864:20::2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vApV3-002n2F-0a for pgsql-general@postgresql.org; Mon, 20 Oct 2025 13:00:33 +0000 Received: by mail-oa1-x2e.google.com with SMTP id 586e51a60fabf-3c97709a4fbso1252420fac.0 for ; Mon, 20 Oct 2025 06:00:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760965231; x=1761570031; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=KdtwgqTzLsun4ED4a5ywu3trPY0dWTy6hO5DEevrYK8=; b=JgBGJFfVXp4q9kCuUfhWefTqcHgbQt/OPHD7sTlFA2QsB2szmS2FsCYDW9Zz7zZD9s cIZstc6aNUORfzy4Mt/ioTLahhcmwXHW/Zy6C/oXw6VRa5fk1ZanJmhG8IKVnN7eS17+ HO7sRVq5rFMh8rrHB78mMbjDaPKlpLkJch2qHauRDOTUgg82WnS8wTI1HCSnTd2/FT13 BVZMNvNPMMiiT584j+LlmdG7b+8c+qWwQf+nU6b5ULfL/c42FtOAHQcB1eBpj+SBmL+a JRrdFNXIvYlNzvsVGyuhdnZW0NlD5JBl1/hUUiQn4AWAsXznUQm5MIPUx0oeBwjccPg2 y5ow== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760965231; x=1761570031; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=KdtwgqTzLsun4ED4a5ywu3trPY0dWTy6hO5DEevrYK8=; b=nbXOIR1Bff0cBCMBvH0LgkDqabTLkMqxhnvIXz7yHuGO6c4YFsVASnAedbQZOInU9u 0piZGvypAuJ/COeuBj7B/WW2jr+yS2HvO7KMQemqxZu7m3KMs12XbP6rYXoZlhIL18fG y12O8sHDuUbTd5ZUDsdXHawiKd+BePIjtBvGkQTAK+LC73j1fhuBJ2bbqEYQUdGs6bSQ 9MRxJBnayOd4kryPW1aDBRJR6OoJ4JzN++ee+2kWVSwyQsGvLkLE8dcSJPn/5k9Qvnu5 g0/y5ThHdeTXT43z2QOImmt0PmJoH3jDmQxkKJUwGQJ52LncLAhJVWNg645K5xldFgHm t26A== X-Gm-Message-State: AOJu0YzsKZc1TOHUhFjLUUVEJDXxoh/vopiFUJ1Qpe/yX6E6jBMw5FiQ qLjyDLIGAfy9y5WSAxjE4pob+7g7SJQSIjae/jvrnArT3b5Ezlv7ouNY/qJoGUvhculqXBzs8MY N0pud/fnkfS7Wemy+4xAdHCl+vtBJwP6u9w== X-Gm-Gg: ASbGncsZMu3p8BrYaSEZ4zGoxEGtE59HJSz5mHWZwMNjihrfRcByrMMB/ODTUaiAI4B IQGz2nFi6mVYSkn1I7FpQ5hNxL7crFIkHADND+C8ViHCSDLrTi9Rq9VFb6tqq+ZXikmT3jhiZXM pn5/vMvldX2sXpaPs19x29uLCy0c+71L8BNFQ3MrqKGgt9Jax2h9AheINloignxMyY+2+jqgB3D Z+yTe+uwnV9lJCqx6tkZD7ks7UPm6m42cO3YB0trgB22LgQqA3ztLpv9WiEtg== X-Google-Smtp-Source: AGHT+IE5yNzjTwsKQdyNf3kQytKFF/ZHieAizscjB8LUli+pkBDzTEA3YT+NvAtCz7JfR+85y5cUl3e5Sgc6PEL9pFY= X-Received: by 2002:a05:6870:64a9:b0:30b:b045:18df with SMTP id 586e51a60fabf-3c98d10dc70mr5551454fac.35.1760965230842; Mon, 20 Oct 2025 06:00:30 -0700 (PDT) MIME-Version: 1.0 References: <2d6e71ef-dbd0-a9c8-b819-c8b97b630c8@appl-ecosys.com> <769142BB-E2E0-4943-A8FB-A9F8FB7B4932@gmail.com> <8ed458fc-e661-8823-d394-75af4b7fd9e@appl-ecosys.com> In-Reply-To: <8ed458fc-e661-8823-d394-75af4b7fd9e@appl-ecosys.com> From: Ron Johnson Date: Mon, 20 Oct 2025 09:00:19 -0400 X-Gm-Features: AS18NWAULF2MEiNuKzG49WYJO72ALrwqXdiLLilLlbKV7jdofFgl_XhAjTP6haU Message-ID: Subject: Re: Convert date and time colums to datetime To: pgsql-general Content-Type: multipart/alternative; boundary="0000000000000bdb19064196ab08" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000bdb19064196ab08 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Oct 20, 2025 at 8:58=E2=80=AFAM Rich Shepard wrote: > On Mon, 20 Oct 2025, Rob Sargent wrote: > > >> Okay. Now I'm curious: why do you write this? > > > 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. > > Rob, > > Since either way works I'll save the time cost of converting because my > tables will never be really large. > Virtual columns exist: have both! --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --0000000000000bdb19064196ab08 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Oct 20, 2025 at 8:58=E2=80=AFAM R= ich Shepard <rshepard@appl-e= cosys.com> wrote:
On Mon, 20 Oct 2025, = Rob Sargent wrote:

>> Okay. Now I'm curious: why do you write this?

> 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.

Rob,

Since either way works I'll save the time cost of converting because my=
tables will never be really large.
=C2=A0
Vi= rtual columns exist: have both!

--
Death to <Redacted>, and butter sauce.
Don&#= 39;t boil me, I'm still alive.
<Redacted> lobster!
--0000000000000bdb19064196ab08--