DuckDB date types? | Observable | Observable
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
ojs
Comments (5)
Ian Johnson
Nov 16, 2021
this is what i want: javascript date object for the date field (this is from the typed csv parsing)
Reply
Ian Johnson
Nov 16, 2021
instead I get a string field when passing the csv to duckdb
Reply
Ian Johnson
Nov 16, 2021
I was able to load a parquet file with TIMESTAMP_MILLIS for the date field, and the type is shown as TIMESTAMP here!
Reply
Ian Johnson
Nov 16, 2021
however, when I run the query I get milliseconds instead of a JS date object, which I would prefer
Reply
Ian Johnson
Nov 16, 2021
I can do various timestamp functions tho, which is nice!
https://duckdb.org/docs/sql/functions/dateformat
Reply
Add comment
Subscribe to notifications
© 2026 Observable, Inc.
Terms of service
Privacy policy
Product
About
Pricing
Documentation
Release notes
Contact us
Open source
Notebook Kit
Plot
D3
Community
Explore
Forum
Bluesky
YouTube
X
Observable
Sign up
Observable
Ian Johnson
1
Reply
Reply
Reply
Reply
Reply
Add comment
Subscribe to notifications
0
DuckDB date types? | Observable | Observable