HOURS_DIFF

Learn how to use the HOURS_DIFF date/time function in PlaidCloud Lakehouse. Returns the number of hours between two datetimes - with syntax and examples.

Returns the number of hours between two datetimes.

Analyze Syntax

func.hours_diff(<end>, <start>)

Analyze Examples

func.hours_diff('2024-01-02 10:00:00', '2024-01-01 10:00:00')

┌────┐
│ 24  │
└────┘

SQL Syntax

HOURS_DIFF(<end>, <start>)

SQL Examples

SELECT HOURS_DIFF('2024-01-02 10:00:00', '2024-01-01 10:00:00');

┌────┐
│ 24  │
└────┘