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 <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1v7JQl-000iDz-Cd
	for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Oct 2025 20:09:35 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1v7JQi-00EAFN-EC
	for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Oct 2025 20:09:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <nathandbossart@gmail.com>)
	id 1v7JQi-00EAFF-5T
	for pgsql-bugs@lists.postgresql.org; Fri, 10 Oct 2025 20:09:33 +0000
Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <nathandbossart@gmail.com>)
	id 1v7JQg-001TOI-2V
	for pgsql-bugs@lists.postgresql.org;
	Fri, 10 Oct 2025 20:09:32 +0000
Received: by mail-io1-xd2b.google.com with SMTP id
 ca18e2360f4ac-917be46c59bso250199239f.1
        for <pgsql-bugs@lists.postgresql.org>;
 Fri, 10 Oct 2025 13:09:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1760126968; x=1760731768;
 darn=lists.postgresql.org;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to;
        bh=NiWonh4lCUVPULezFxkLaBcLNYwemvGVW3uolxzbH3U=;
        b=RzqnW3WPcQdTKTUvKD2EX9FPVf7OcCrfFsAPuhLbignW2jdow78etyYjB9taH+6T4n
         ADF+4mAP4qjR7tXpmK8HG2IQ8zzwfK2iK7yQBD0E/R+Ce3Mzczsw+iLARlFAbxyfwP30
         faX00QSSoVihOJS1vMu09C6ow30NG/SZYeiEkpEJnn8lpAHani1iu8WWYuyKnJS48CLS
         nw0NRyi9OC2Cruj7CvZVLJnyP7Z6+A+BEnvdGkZiE0oxDkvLaoZiGuUKjh/l+lnpcG8F
         HC4K+AE/JNX1dYzzbaHdKyqeIC1niK3K4G6cu5r2Tclr3weVHCvD0QIUP57uWHEWy1Id
         tVRQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1760126968; x=1760731768;
        h=in-reply-to:content-disposition:mime-version:references:message-id
         :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date
         :message-id:reply-to;
        bh=NiWonh4lCUVPULezFxkLaBcLNYwemvGVW3uolxzbH3U=;
        b=gIhFKXS42lmqL9zQ566rThv1pNG4WmgWjv+MTvh3hTzyVy2T1z6SJpKDe9TPyVoN4u
         Klr0Eg0tI/ekUWdUuPn0C1nfgN1vN5dgDOxlqm/XYijSKEWOa5sYH/tYSfDt3Pr/kZF4
         3YKFUpz9CXIFnN4L6QgmzNWp1G7VS75S+2VRqAcs6CjlaB1E6vxgjlRb0qQE417MZs6j
         mqwNM/tMzH5Zw7YkDNTvITcBUghgDYOtWhUc3QU3+a4si3RSc/oO8MxlcNAJ+t525nZJ
         9hZnR4T566z/nuCVEzjz2duz28WgFGdxPm/Fygz3PDxKvP+kT1ccgaRmQWgJMZ6tquQy
         +wMA==
X-Gm-Message-State: AOJu0YwVGa3gLV6O5ss8lrap3qpuar2KBtcCjlXenx0GGthOeeTL6r0s
	i/T1bjb/upVhPPOy2CUcrlrJvksHosXwQ93LmEpOo7TzGqobNpj1dTi4
X-Gm-Gg: ASbGncvohTdRgB6RqOAJW3sRCf+M5dVKkPmw3QpCUiUl9RDp2O3nmnFL+EWLJ8gGO8w
	up56A6YLONXCsN0U4b8KRDRiCWRVu/3SEMfpAz0Kw6sJcpLCYMyp+Se4F5R7LU9o2wHUv+XxFX/
	ADs+rzd94HPeYn080f2dp2Kv9mBxS6xSTKXimDeqopva1+mTNT8ep7EhizPuZcsPeCP3zZW5rxM
	jGCS9kiEO7Q5juPSMgi1vjXZ90ijewuA3uWkPhxTIFSwXzGd4JOfOkdK6GFMoRsqCxdQIv/D26y
	r65iml4B2M7oezjSm6GGeC90LaBtXQJ1Pl7pMeEtCfxj4QKAOsMJtxeBct4Fe95K5WdYHXEJc9c
	+LvjK5o87JH3jbbWI8I/HhmLsS7XFV64ZLjgU83FjZDhTrB0dyVFBquw7APF5LRhvl3ETRkijal
	XHPRaikYkU6C7/ueJ1y1Nu7nN01vgxMU4=
X-Google-Smtp-Source: 
 AGHT+IHeUeEThqhIWYJN7+92l+kNbunNaZK6ulrBA0dEms5v0I+4D4AACOnK5O5Mg16UFiNBTmuRxA==
X-Received: by 2002:a05:6e02:3c04:b0:42e:712c:b15 with SMTP id
 e9e14a558f8ab-42f87351fefmr132742635ab.1.1760126968338;
        Fri, 10 Oct 2025 13:09:28 -0700 (PDT)
Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net.
 [162.195.168.172])
        by smtp.gmail.com with ESMTPSA id
 e9e14a558f8ab-42f902962fbsm24545705ab.18.2025.10.10.13.09.27
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 10 Oct 2025 13:09:27 -0700 (PDT)
Date: Fri, 10 Oct 2025 15:09:25 -0500
From: Nathan Bossart <nathandbossart@gmail.com>
To: Zane Duffield <duffieldzane@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: Date/Time parsing of ISO 8601 timestamps with commas
Message-ID: <aOln9b9-ZXmVYwHe@nathan>
References: 
 <CACMiCkXtic8S50soCVHLsbpw8CbMrwbu4RfR1yUWfDgm+hO6OA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CACMiCkXtic8S50soCVHLsbpw8CbMrwbu4RfR1yUWfDgm+hO6OA@mail.gmail.com>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: <https://www.postgresql.org/message-id/aOln9b9-ZXmVYwHe%40nathan>
Precedence: bulk

On Fri, Oct 10, 2025 at 10:43:04AM +1100, Zane Duffield wrote:
> I noticed today that PostgreSQL doesn't support parsing ISO 8601 timestamps
> that use a comma as the decimal separator.

I found various threads about this in the archives, including this one:

	https://postgr.es/m/flat/152271186941.1442.12179299369295226185%40wrigleys.postgresql.org

-- 
nathan