How do you convert unix timestamps (epoch) to dates/datetime/timestamp?

[ScottWilliamAnderson]

E.g. given a basic example:

import ibis
ibis.memtable({'unix_time': [1738692000]})

I've seen the epoch_seconds temporal expression: https://ibis-project.org/reference/expression-temporal.html#ibis.expr.types.temporal.TimestampValue.epoch_seconds

But I don't see any word in the docs on how to convert from UNIX to datetime/timestamp column.
Perhaps I'm mistaken- is there a way to do this?

[ScottWilliamAnderson]

import ibis
unix = 1738260000
ibis.date(1970, 1, 1).add(ibis.interval(unix))
>NotImplemented

Is that right? Could I just confirm that there is no way of doing this at the moment?

Edit:
I've found a workaround, but this removes the timestamp within the date, and only keeps the date. I am not sure how accurate it is for large epochs:

import ibis
unix = 1738260000
(ibis.date(1970, 1, 1).add(ibis.interval(unix).as_unit('D'))).as_scalar().execute()
>datetime.date(2025, 1, 30)

When it should return:
datetime.datetime.utcfromtimestamp(unix)
>datetime.datetime(2025, 1, 30, 18, 0)

[gforsyth]

There should be an as_timestamp method on the column you can use for this (and then specify the unit that that int-column is representing (usually seconds)

[ins] In [14]: t
Out[14]: 
┏━━━━━━━━━━━━┓
┃ unix_time  ┃
┡━━━━━━━━━━━━┩
│ int64      │
├────────────┤
│ 1738692000 │
└────────────┘

[ins] In [15]: t.unix_time.as_timestamp("s")
Out[15]: 
┏━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┓
┃ TimestampFromUNIX(unix_time, SECOND) ┃
┡━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━┩
│ timestamp                            │
├──────────────────────────────────────┤
│ 2025-02-04 18:00:00                  │
└──────────────────────────────────────┘

[ScottWilliamAnderson]

Brilliant, thank you!