Thanks @RPGPGM for everything you do… RPGPGM.com one of the greatest #IBMi resource out there! #rpgle #SQL twitter.com/rpgpgm/status/…- imPower Technologies (@jbuck_imPower)18:26 – Mar 15, 2023Quoted Tweet:Thank you to imPower Technologies (@jbuck_imPower) for their continued advertising on #RPGPGM💙#IBMi #IBMChampion pic.twitter.com/o2CHe2qAPN- Simon Hutchinson (@RPGPGM)17:58 – Mar 15, 2023 Read More
#IBMi Modernization is always on my mind. Since 1988 my book “The Modern RPG Language” ushered in a era of modern RPG developers that wrote modern RPG. Today those developers and new ones are developing RPG IV with embeded SQL. I call this modern SQL styl… SQL iQuery for #IBMi (aka Q38) (@sqliquery)
#IBMi Modernization is always on my mind. Since 1988 my book “The Modern RPG Language” ushered in a era of modern RPG developers that wrote modern RPG. Today those developers and new ones are developing RPG IV with embeded SQL. I call this modern SQL styl…lnkd.in/gwJFE2mT- SQL iQuery for #IBMi (aka Q38) (@sqliquery)17:48 – Mar 15, 2023 Read More
Come see me in action today at #WMCPA #iCon23. Lots of cool stuff to show 💙#IBMi #rpgpgm #IBMChampion Simon Hutchinson (@RPGPGM)
Come see me in action today at #WMCPA #iCon23.Lots of cool stuff to show 💙#IBMi #rpgpgm #IBMChampion pic.twitter.com/uqut09YikL- Simon Hutchinson (@RPGPGM)05:00 – Mar 15, 2023 Read More
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
