TIMESTAMP_DIFF

Learn how to use the TIMESTAMP_DIFF datetime function in PlaidCloud Lakehouse. Calculates the difference between two timestamps and returns the result as an...

Calculates the difference between two timestamps and returns the result as an INTERVAL.

Analyze Syntax

func.timestamp_diff(<timestamp1>, <timestamp2>)

Analyze Examples

func.timestamp_diff(func.to_timestamp('2025-02-01'), func.to_timestamp('2025-01-01'))
┌────────────────────────────────────────────────────────────────────────────────────────┐
│ func.timestamp_diff(func.to_timestamp('2025-02-01'), func.to_timestamp('2025-01-01'))  │
├────────────────────────────────────────────────────────────────────────────────────────┤
│ 744:00:00                                                                              │
└────────────────────────────────────────────────────────────────────────────────────────┘

SQL Syntax

TIMESTAMP_DIFF(<timestamp1>, <timestamp2>)

Return Type

INTERVAL (formatted as hours:minutes:seconds).

SQL Examples

This example shows that the time difference between February 1, 2025, and January 1, 2025, is 744 hours, corresponding to 31 days:

SELECT TIMESTAMP_DIFF('2025-02-01'::TIMESTAMP, '2025-01-01'::TIMESTAMP);

┌──────────────────────────────────────────────────────────────────┐
│ timestamp_diff('2025-02-01'::TIMESTAMP, '2025-01-01'::TIMESTAMP) │
├──────────────────────────────────────────────────────────────────┤
│ 744:00:00                                                        │
└──────────────────────────────────────────────────────────────────┘