Category: Feedly

Posted on

Getting the hours, minutes, and seconds from a difference in timestamps with SQL Simon Hutchinson

​I have timestamp columns in a Db2 Table that I need to give the difference in hours, minutes, and seconds. Preferably I would put these into separate columns that I can then use in various ways in subsequent jobs and programs. All you really needs to know about the Table I will be using is that it is called TESTTABLE, and the timestamp columns I need to calculate the difference between are: FROM_TIMESTAMPTHRU_TIMESTAMP I can easily determine the difference between the two with the following SQL statement: Read more » Read More 

Posted on

Thanks @RPGPGM for everything you do… one of the greatest #IBMi resource out there! #rpgle #SQL imPower Technologies (@jbuck_imPower)

​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 

Posted on

#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 

Verified by MonsterInsights