Re: SQL function WEEK_ISO for years beyond 2039

Thanks for clarifying this, Barbara - my statement was too broad, was meant in more of a "conceptual" way.

Best of the New Year to you!
Vern


On Wed, 8 Jan, 2025 at 2:28 PM, Barbara Morris <bmorris@xxxxxxxxxx> wrote:


To: midrange-l@xxxxxxxxxxxxxxxxxx

On 2025-01-03 2:20 p.m., VERNON HAMBERG Owner via MIDRANGE-L 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.

The change for the base date doesn't affect everything.

It says
"Note: This environment variable update only effects commands with a
parameter of TYPE(*DATE). Existing RPG or COBOL programs as well as Db2
are not effected by this update. Dates need to be converted to a
4-digit-year value."

It's not just existing RPG programs. RPG will keep 1940 as the base year
for 2-digit dates.

See this recent RPG compiler enhancement where you can get a
compile-time warning or error if you are using a 2-digit-year date format.

RPG Cafe: Fall 2024: Find where you use 2-digit years, to avoid the
"2039 problem"
https://www.ibm.com/support/pages/node/7172105