Teradata Tutorial
Teradata Basics
Teradata Advanced
Teradata Useful Resources
Selected Reading
Teradata Basics
- Teradata - SubQueries
- Teradata - Joins
- Teradata - Primary Index
- Teradata - CASE & COALESCE
- Teradata - Aggregate Functions
- Teradata - Built-in Functions
- Teradata - Date/Time Functions
- Teradata - String Manipulation
- Teradata - SET Operators
- Logical & Conditional Operators
- Teradata - SELECT Statement
- Teradata - Data Manipulation
- Teradata - Tables
- Teradata - Data Types
- Teradata - Relational Concepts
- Teradata - Architecture
- Teradata - Installation
- Teradata - Introduction
Teradata Advanced
- Teradata - BTEQ
- Teradata - FastExport
- Teradata - MultiLoad
- Teradata - FastLoad
- Teradata - Performance Tuning
- Teradata - User Management
- Teradata - Data Protection
- Teradata - OLAP Functions
- Teradata - Partitioned Primary Index
- Teradata - JOIN Strategies
- Teradata - Stored Procedure
- Teradata - Macros
- Teradata - Views
- Teradata - Join Index
- Teradata - Hashing Algorithm
- Teradata - Explain
- Teradata - Compression
- Teradata - Statistics
- Teradata - Secondary Index
- Teradata - Space Concepts
- Teradata - Table Types
Teradata Useful Resources
- Teradata - Discussion
- Teradata - Useful Resources
- Teradata - Quick Guide
- Teradata - Questions & Answers
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
Teradata - Built-in Functions
Teradata - Built-in Functions
Teradata provides built-in functions which are extensions to SQL. Following are the common built-in functions.
Function | Result |
---|---|
SELECT DATE; | Date -------- 16/01/01 |
SELECT CURRENT_DATE; | Date -------- 16/01/01 |
SELECT TIME; | Time -------- 04:50:29 |
SELECT CURRENT_TIME; | Time -------- 04:50:29 |
SELECT CURRENT_TIMESTAMP; | Current TimeStamp(6) -------------------------------- 2016-01-01 04:51:06.990000+00:00 |
SELECT DATABASE; | Database ------------------------------ TDUSER |