Skip to content

datediff.md

Latest commit

 

History

History
24 lines (20 loc) · 537 Bytes

datediff.md

File metadata and controls

24 lines (20 loc) · 537 Bytes
categories
datetime

datediff rewrite

Spark datediff(endDate, startDate) takes 2 args with end first. Feldera DATEDIFF(unit, start, end) takes 3 args with unit first and start/end swapped.

Spark:

SELECT order_id,
  datediff(delivered_at, shipped_at) AS days_to_deliver,
  datediff(shipped_at, ordered_at)   AS days_to_ship
FROM orders;

Feldera:

SELECT order_id,
  DATEDIFF(DAY, shipped_at, delivered_at) AS days_to_deliver,
  DATEDIFF(DAY, ordered_at, shipped_at)   AS days_to_ship
FROM orders;