Sign in Subscribe
Share

Efficient Teradata Date Calculations Avoiding INTEGER Values

Learn how Teradata stores dates internally as INTEGER values and how to efficiently calculate dates after 1900-01-01 using a simple formula. Get more useful Teradata date calculations in this article.

Efficient Teradata Date Calculations Avoiding INTEGER Values
sql3

This post is for subscribers only

Already have an account? Sign in.

Subscribe to DWHPro Letters

Practical field notes on enterprise data engineering, production AI systems, platform migration, and the senior engineering market.
Written by Roland Wenzlofsky Founder of DWHPro Author of Teradata Query Performance Tuning
Get the next issue
Subscribe