SQL Query to get DATE interval from SYSDUMMY1

Jan 4, 2017

Tags: How to find date difference in DB2

SQL Query to get DATE interval from SYSDUMMY1

I have shared a SQL query that you can use it to get differences of two dates using sysdummy1.

db2 >>
SELECT 
(current date) - date(2008-08-06) 
FROM sysibm.sysdummy1

More: DB2 DATE and TIMESTAMP examples

Srini

Data Engineer with deep AI and Generative AI expertise, crafting high-performance data pipelines in PySpark, Databricks, and SQL. Skilled in Python, AWS, and Linux—building scalable, cloud-native solutions for smart applications.

Latest Posts

Ingesting Data from AWS S3 into Databricks with Auto Loader: Building a Medallion Architecture

December 18, 2025
Building Scalable Data Pipelines with dlt-meta: A Metadata-Driven Approach on Databricks

December 9, 2025
Exploring Databricks Unity Catalog – System Tables and Information _Schema: Use Cases

December 8, 2025
PySpark Functions Real Use Cases

November 29, 2025

SQL Query to get DATE interval from SYSDUMMY1

Share this:

Latest Posts

Ingesting Data from AWS S3 into Databricks with Auto Loader: Building a Medallion Architecture

Building Scalable Data Pipelines with dlt-meta: A Metadata-Driven Approach on Databricks

Exploring Databricks Unity Catalog – System Tables and Information _Schema: Use Cases

PySpark Functions Real Use Cases