evidence icon indicating copy to clipboard operation
evidence copied to clipboard

[Bug]: Null Dates in DataTable are Shown as Epoch

Open mtdewulf opened this issue 11 months ago • 1 comments

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":

Image

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.

Slack thread.

mtdewulf avatar Mar 04 '25 21:03 mtdewulf

This is much worse than an annoyance. Is there a suggested workaround?

kennan-simpliphy avatar Apr 05 '25 18:04 kennan-simpliphy