NEUGC - 2022 has ended
Back To Schedule
Wednesday, April 13 • 1:00pm - 2:00pm
Date and Time Calculation with SQL

Sign up or log in to save this to your schedule, view media, check-in, leave feedback and see who's attending!

Feedback form is now closed.
Calculating dates and times correctly within commercial applications are can be critical. SQL has become very powerful in date calculation and date operation functions. In this way SQL includes functions for retrieving the day of the week (as number of name), calculating the week according the ISO guide lines, determining the month end or the date of the next Wednesday or Friday. Additionally, SQL includes scalar functions that allow to convert almost any (valid) character representation of a date, time or timestamp into a real timestamp and vice versa. 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.
Learning Objectives:
              In this session you will learn how to convert character and numeric dates, times and timestamps in almost any format into a valid timestamp and vice versa. You will also learn how to calculate the differences between date and time values, how to add or subtract date and time values to a date, time or timestamp and how to extract a date/time part from a date, time, timestamp or calculated time/date difference. You will also get an overview over the available scalar date and time functions.
.Audience:           SQL Users, Programmers and database administrators who (often) have to convert numeric or character dates into real dates and who have to calculate with date and time values.

avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, Birgitta Hauser - Modernization - Education - Consulting on IBM i
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM  i application... Read More →

Wednesday April 13, 2022 1:00pm - 2:00pm EDT
Grand Centre