Message-ID: <gh-pgjdbc-pgjdbc-1325-c3126556512@github.com>
From: "davecramer (@davecramer)" <noreply+davecramer@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Mon, 28 Jul 2025 10:21:05 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #1325: Additional jsr 310 support
In-Reply-To: <gh-pgjdbc-pgjdbc-1325@github.com>
References: <gh-pgjdbc-pgjdbc-1325@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: davecramer
X-GitHub-Comment-Id: 3126556512
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 1325
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/1325#issuecomment-3126556512
Content-Type: text/plain; charset=utf-8

> A caveat with `ZonedDateTime` is it has neither `MIN` nor `MAX` constants, so it is not clear how to map from `+-infinity` to `ZonedDateTime`. The reason for missing `MIN/MAX` is it is unclear which timezone would have MIN/MAX value.
> 
> I think it might be safe to throw an error if user attempts accessing `infinity` values with `ZonedDateTime`.
> 
> [@bokken](https://github.com/bokken) , [@marschall](https://github.com/marschall) , [@davecramer](https://github.com/davecramer) , WDYT about `infinity` for `ZonedDateTime`?

Seems like the spec is a lacking here. According to the docs ZonedDateTime is supposed to be OffsetDateTime with zone rules but it seems like the ZonedDateTime missed having MIN/MAX.