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
Observable
Sign in
Observable
Ian Johnson
1
Reply
Reply
Reply
Reply
Reply
Add comment
Subscribe to notifications
0
DuckDB date types? | Observable | Observable