Schlagwort-Archive: RPG

Rational Developer for i (RDi) 9.8 – Tips & Tricks – Version 9.8.0.3 update

Veröffentlicht am von
2

With the availability of RDi 9.8.0.3 and the latest compiler PTFs I updated my compiled list of RDi 9.8 tips and tricks that piled up since the first beta. 

I decided to also post it to the TechXchange community: https://community.ibm.com/community/user/power/blogs/daniel-gross/2024/12/03/rdi98-tips

So after using version 9.8 since the BETA releases, I have compiled my favorite information, tips and tricks for it. This compilation is a very personal and loose collection – without claiming any completeness or that it will work „on your computer“. As always, your mileage might vary.

Weiterlesen →

Converting timestamps from local timezone to UTC with RPG and SQL

Veröffentlicht am von
Antworten

When timestamps are stored in a database table, they are often stored in local time. This is not bad at all, but if you have to compare or coordinate timestamps of different time zones, it quickly gets complicated due to different time offsets, different daylight saving time rules and so on. So it would be nice, to convert timestamps from local time to UTC and back. We will create a RPG procedure to do that, and make it available as a SQL user defined function (UDF).

Weiterlesen →