Yeah, there are in the underlying library, dtype-next : https://cnuernber.github.io/dtype-next/tech.v3.datatype.functional.html https://cnuernber.github.io/dtype-next/tech.v3.datatype.datetime.html

:hugging_face:

Follow up… what’s the easiest or idiomatic way of comparing (filtering) on dates? Must be a common use case 😳 🙂 I have :local-date-time columns 🙂

For this specific case it’s data I’m happy to filter out when ingesting, if possible. Is that possible?

filter-column - they should be java time localdates

tick is the recommended pathway

https://github.com/juxt/tick

What are you trying to achieve? You may be able to get by with processing excel/CSV files from clojure and using the clojure.core functions which are easy to learn etc. This isn't like Python where you need a library like Pandas. Clojure is already great at data processing.

Thanks all. And @UJVEQPAKS, yeah, that’s definately a grey area where, as a newbie, drawing the lines is definately tricky. I’m doing this explicitly to get away from “Excel for everything”, and with time maybe having my colleagues working with Clerk notebooks, etc. More thinking do be done 🙂

https://www.youtube.com/watch?v=WA5O7jNoNGE @UDRJMEFSN thank you for pointing to duckdb.

@U0516053R - we are excited we have been looking for something like that for a while. Way back perhaps more than a year ago you can find zulip musings about how to add an SQL engine on top of a collection of TMD datasets or sequences of datasets. This was before we took the most recent look at duckDB and it just feels like a major missing piece of the puzzle.

I was talking to my friend earlier today "it's been a long time since I've seen something so useful"