DATEDIFF (Lakehouse v2)

Renvoie le nombre de jours entre deux dates.

Syntaxe Analyze

func.datediff(<end_date>, <start_date>)

Exemples Analyze

func.datediff('2024-03-01', '2024-01-01')

┌────┐
│ 60  │
└────┘

Syntaxe SQL

DATEDIFF(<end_date>, <start_date>)

Exemples SQL

SELECT DATEDIFF('2024-03-01', '2024-01-01');

┌────┐
│ 60  │
└────┘