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 

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 

Verified by MonsterInsights