evidence
evidence copied to clipboard
[Bug]: Null Dates in DataTable are Shown as Epoch
Describe the bug
Null dates are shown as the Unix epoch (1970-01-01).
Steps to Reproduce
Add the following markdown file to your project:
```sql bad_date
select
null::date as "a_date"
from (values (1)) as t
```
<DataTable data={bad_date}/>
Observe the date as "1970-01-01":
Logs
System Info
System:
OS: macOS 15.3.1
CPU: (10) arm64 Apple M1 Pro
Memory: 1.73 GB / 32.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 18.17.1 - ~/.nvm/versions/node/v18.17.1/bin/node
Yarn: 1.22.17 - /usr/local/bin/yarn
npm: 9.6.7 - ~/.nvm/versions/node/v18.17.1/bin/npm
pnpm: 10.4.1 - ~/.nvm/versions/node/v18.17.1/bin/pnpm
Browsers:
Chrome: 133.0.6943.142
Safari: 18.3
npmPackages:
@evidence-dev/bigquery: ^2.0.9 => 2.0.9
@evidence-dev/core-components: ^5.1.1 => 5.1.1
@evidence-dev/csv: ^1.0.14 => 1.0.14
@evidence-dev/databricks: ^1.0.8 => 1.0.8
@evidence-dev/duckdb: ^1.0.13 => 1.0.13
@evidence-dev/evidence: ^40.0.7 => 40.0.7
@evidence-dev/motherduck: ^1.0.4 => 1.0.4
@evidence-dev/mssql: ^1.1.2 => 1.1.2
@evidence-dev/mysql: ^1.1.4 => 1.1.4
@evidence-dev/postgres: ^1.0.7 => 1.0.7
@evidence-dev/snowflake: ^1.2.2 => 1.2.2
@evidence-dev/source-javascript: ^0.0.2 => 0.0.2
@evidence-dev/sqlite: ^2.0.7 => 2.0.7
@evidence-dev/trino: ^1.0.9 => 1.0.9
Severity
annoyance
Additional Information, or Workarounds
Possibly related to #3092.
This is much worse than an annoyance. Is there a suggested workaround?