# Working with Functions, Times, Dates, & Intervals

• 14 videos | 1h 31m 52s
Teradata supports the use of functions, expressions, and operators to perform operations on data. Explore attribute, string, and analytical functions, as well as times, dates, and intervals in Teradata.

## WHAT YOU WILL LEARN

• Identify the different types of functions in teradata and how expressions and sql operators are used Use arithmetic functions and operators on data in teradata Use attribute functions to return descriptive information about their operand in teradata Use string functions to perform operations on strings of data in teradata Use regular expression functions on data in teradata Use the analytical functions in teradata Use case expressions to evaluate a set of expressions in teradata
• Use calendar functions to work with dates, months, and years in teradata Use ansi datetime expressions to do computations with time zones and interval values in teradata Use ansi interval expressions to perform calculations on interval values in teradata Use arithmetic operators, ansi datetime, and interval data types in teradata Use scalar operations with datetime functions to work with dates and times in teradata  Use the different datetime and interval functions, last_day, next_day, trunc, round, extract in teradata

## IN THIS COURSE

• In this video, you will identify the different types of functions in Teradata and how expressions and SQL operators are used.
• During this video, you will learn how to use arithmetic functions and operators on data in Teradata.
• 3.  Using Attribute Functions
In this video, find out how to use attribute functions to return descriptive information about their operand in Teradata.
• 4.  Using String Functions
Learn how to use string functions to perform operations on strings of data in Teradata.
• 5.  Using Regular Expression Functions
During this video, you will learn how to use regular expression functions on data in Teradata.
• 6.  Using Analytical Functions
Find out how to use the analytical functions in Teradata.
• 7.  Using CASE Expressions
In this video, you will learn how to use CASE expressions to evaluate a set of expressions in Teradata.
• 8.  Using Calendar Functions
Learn how to use calendar functions to work with dates, months, and years in Teradata.
• 9.  Using ANSI DateTime Expressions
In this video, you will learn how to use ANSI DateTime expressions to do computations with Time Zones and interval values in Teradata.
• 10.  Using ANSI Interval Expressions
In this video, you will use ANSI Interval expressions to perform calculations on Interval values in Teradata.
• 11.  Using Arithmetic DateTime and Interval Functions
Find out how to use arithmetic operators, ANSI DateTime, and Interval Data Types in Teradata.
• 12.  Using Scalar Operations and DateTime Functions
In this video, find out how to use scalar operations with DateTime functions to work with dates and times in Teradata.
• 13.  Using DateTime and Interval Functions (Part 1)