Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
mtdewulf opened this issue Mar 4, 2025 · 0 comments
Open

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

mtdewulf opened this issue Mar 4, 2025 · 0 comments
Labels
bug Something isn't working to-review Evidence team to review

Comments

@mtdewulf
Copy link

mtdewulf commented Mar 4, 2025

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 mtdewulf added bug Something isn't working to-review Evidence team to review labels Mar 4, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working to-review Evidence team to review
Projects
None yet
Development

No branches or pull requests

1 participant