In this free webinar, @Kyndryl will overview the main challenges of IBM i modernization and discuss best practices for addressing them. Join Richard Baird on March 23, 2023 @ 11:00AM (CT) for this #POWERCast! Register today: #IBMiEducation #COMMONug COMMON – A Users Group (@COMMONug)

​In this free webinar, @Kyndryl will overview the main challenges of IBM i modernization and discuss best practices for addressing them. Join Richard Baird on March 23, 2023 @ 11:00AM (CT) for this #POWERCast! Register today: bit.ly/3yEysXW #IBMiEducation #COMMONug pic.twitter.com/9g0D8DtO4g- COMMON – A Users Group (@COMMONug)07:15 – Mar 15, 2023 Read More 

Improved SQL built in function for calculating difference between timestamps Simon Hutchinson

​I had written about the Db2 built in function TIMESTAMPDIFF, which is used to calculate the difference between two timestamps and return the difference in various different units of time. In the latest Technology Refreshes, IBM i 7.5 TR1 and IBM i 7.4 TR7, a new and improved built in function, TIMESTAMPDIFF_BIG, was introduced. TIMESTAMPDIFF had issues in being able to correctly return the difference in microseconds. IBM’s documentation says that the new TIMESTAMPDIFF_BIG will do that correctly. The syntax of the two built in functions, BiF, is the same: Read more » Read More 

Verified by MonsterInsights