Difference between dates

[vmsaipreeth]

Hi Team,

Lets say we have two date columns in a ibis table. How simply can I get the difference of these date columns in no.of days?

Backend: Trino

Thanks

[gforsyth]

Hi @vmsaipreeth -- you can use the delta method and specify `day' as the unit:

[ins] In [1]: import ibis

[ins] In [2]: from datetime import date

[ins] In [3]: ibis.options.interactive = True

[ins] In [4]: con = ibis.trino.connect(
         ...:     user="user",
         ...:     password="",
         ...:     host="localhost",
         ...:     port=8080,
         ...:     database="memory",
         ...:     schema="default",
         ...: )

[ins] In [5]: ibis.set_backend(con)

[ins] In [6]: t = ibis.memtable(
         ...:     dict(
         ...:         start_col=[date(2024, 4, 29)],
         ...:         end_col=[date(2025, 4, 29)],
         ...:     ),
         ...: )

[ins] In [7]: t.end_col.delta(t.start_col, "day")
Out[7]: 
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ DateDelta('day', end_col, start_col) ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ int64                                │
├──────────────────────────────────────┤
│                                  365 │
└──────────────────────────────────────┘

[vmsaipreeth]

This worked. Thanks @gforsyth !