cube-js / cube-js/cube

to_timestamp(epoch) not supported yet

Open
#8,901 0 comments 0 reactions 0 assignees View on GitHub
api:sql question
Dominant language
Rust
Stars
20.8k
Forks
2.1k
Avg merge
1d 2h
Merged PRs (30d)
181

Description

**Failed SQL**
```
select updated_at
from orders
where updated_at>to_timestamp(1730562810);
```

**Logical Plan**
```
[cubesql::compile::query_engine] Initial Plan: Projection: #orders.updated_at
Filter: #orders.updated_at > str_to_date(Int64(1730562810))
TableScan: orders projection=None
```

**Version:**
1.1.2

internally to_timestamp calls are converted to str_to_date function which does not take into account of to_timestamp(double)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.