# Working with Functions, Times, Dates, & Intervals

Teradata 14    |    Beginner
• 14 videos | 1h 31m 52s
• Earns a Badge
Rating 4.4 of 34 users (34)
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, add_months, oadd_months, and months_between 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)
Learn how to use the different DateTime and Interval functions: ADD_MONTHS, OADD_MONTHS, and MONTHS_BETWEEN in Teradata.
• 14.  Using DateTime and Interval Functions (Part 2)
Learn how to use the different DateTime and Interval functions: LAST_DAY, NEXT_DAY, TRUNC, ROUND, EXTRACT in Teradata.

## EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

## YOU MIGHT ALSO LIKE

Rating 4.6 of 23 users (23)
Rating 5.0 of 4 users (4)
Rating 5.0 of 7 users (7)

## PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Functions
Rating 4.5 of 43 users (43)
Rating 4.6 of 49 users (49)
Rating 4.5 of 1470 users (1470)