Attending this event?
Tuesday, April 7 • 3:45pm - 5:00pm
Date and Time Calculation with SQL

Sign up or log in to save this to your schedule and see who's attending!

Calculating dates and times correctly within commercial applications are can be critical. Even though RPG can handle real date and times and has been enhanced by several operation codes and built-in-functions, SQL has become much more powerful in date calculation and date operation functions. But there are some features that can be handled easier with RPG. This session will give you an overview over the latest SQL scalar functions for date and time calculation and for conversion between numeric and character date/time representations and real date/time values. You will also learn when to use RPG and when to use SQL and what are the pitfalls.

avatar for Birgitta Hauser

Birgitta Hauser

Fresche Solutions
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany.She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works as... Read More →

Tuesday April 7, 2020 3:45pm - 5:00pm
(D) Commons I
Feedback form isn't open yet.