COMMON Fall Conference & Expo

Calculating date and time values correctly within commercial applications can be critical. SQL has become very powerful in date calculation and date operation functions. In this way SQL includes multiple functions for converting character representations of a date/time value into a real date/time value and vice versa. There are a lot of functions for calculating time differences or determining date information, such as the day of week or the date of the next wednesday without using a calendar table. This session will give you an overview over the SQL scalar functions for date and time calculation.

Learning Objectives:

• Convert character and numeric date and time values into real date and time data types. 
• Calculate date and time differences
• Retrieve date and time information from a date and/or time value or expression, such as the numeric day of week, the week according the ISO guidelines and much more.