Re: SQL function WEEK_ISO for years beyond 2039

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Vern,
What you state is a fact.
And it's also a fact that if you shoot yourself in the foot it's going to
hurt something fierce.
I'd suggest that they stop using two digit years.

The environment variable is optional in 7.5.  It does state that the
default will change in a future release and you will need the environment
variable to change it back to the 1940-2039 range.

On Fri, Jan 3, 2025 at 2:20 PM VERNON HAMBERG Owner via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> Of course, this change to 1970 as the base date means that any date with 2
> digit year that was between 1940 and 1969 is now magically a century later.
>
>
> Cheers
> Vern
>
>
> On Fri, 3 Jan, 2025 at 12:57 PM, Arco Simonse <arco400@xxxxxxxxx> wrote:
>
>
> To: midrange systems technical discussion
>
> Hi Ake,
>
> Not to long ago I have been bitten by the same issue. There are some
> limitations on IBMi for years after 2039. On release 7.5 IBM has added
> support to extend to 2069.
>
>
> https://www.ibm.com/docs/en/i/7.5?topic=ios-changes-1940-2039-date-range-date-formats-2-digit-year
>
> Hope this helps.
>
> Regards,
> Arco

>