Another year milestone has been reached as I celebrate the 13th birthday of RPGPGM.COM. It has been an incredible personal journey since I have published that first post in 2013. Your feedback and encouragement have made all the effort I have spent worthwhile.
What has happened to me in the past twelve months?
A friend asked me if there was a simple way to calculate the "Julian" date when retrieving dates from a DDL table or DDS file with a date type field.
Before I continue I need to describe the difference between the Julian and the Ordinal dates. While we all call a date in YYYYDDD a "Julian" date, that is not correct. The Julian date is a count of days since January 1, 4713 BCE. I found this helpful link describing why it is this date. The correct name for the YYYYDDD date is the Ordinal date, which is recognized by the ISO 8601 standard.
Db2 for i includes a Julian day scalar function. The statement below show me using it with the date June 1, 2026:
01 VALUES JULIAN_DAY('2026-06-01')
|
The result is:
My presentations this month start today, June 1! At 4:00 PM (CT) I am the guest speaker for COMMON N2i as part of their "N2i Getting Started" series. I will be talking about a few of my favorite RPG Built in Functions, BiFs, and why should be using them. This is a longer and more detailed presentation than I gave as part of System i Developer's Lunch & Learn last week.
You can register for this online event by clicking on the link on this page here.
For the rest of the month my presentations take on an international flavor.
Wednesday June 17 at 12:00 PM (ET) I will be virtually hanging out with my friends at the Toronto Users Group (TUG), Canada, talking about supercharding your SQL in RPG programs.
You can register by clicking on the link on this page.
Thursday 25 June I will be talking to COMMON Austria, at 4:00 PM (CET, 9:00 AM (CT)) about what is IBM i? and what is new and useful in CL programming language.
The event is online, and you can register here. Wir sehen uns dort!