teradata-functions

Teradata ISNULL Alternatives

Teradata RPAD - Right Padding

Teradata LPAD - Left Padding

Teradata SQL - Round Numbers to Hundreds or Thousands

Teradata SQL - Get Rid of Spaces from String

Trim Leading or/and Trailing Zeros in Teradata

This page shows how to trim or remove leading or/and trailing zeros using Teradata SQL.

Teradata SQL - Use OREPLACE to Replace or Remove Characters

Teradata SUBSTRING / SUBSTR and REGEXP_SUBSTR Functions

Teradata SQL - TRYCAST / TRY_CAST Function

Teradata SQL - DATEADD Function Alternative for ADD / Subtract Days or Months

Teradata Tutorial – DateTime Related Functions and Examples

This post summarize the common functions that are used when dealing with DateTime datatypes in Teradata.