All too familiar. Luckily, I have built "date time" functions for a relational DBMS before!

I had specifically worked on functions like EXTRACT to pull out different parts like ISO Week numbers, as well as DATEADD and DATEDIFF functions which do date math. It is exceptionally unpleasant!