ExSQL.DateTime (exsql v0.1.5)

SQLite-compatible date/time scalar functions.

All computation follows SQLite's src/date.c:

Internally everything runs as a fractional Julian Day Number times 86,400,000 (milliseconds since Julian Epoch noon).
compute_jd/1 and compute_ymd/1 mirror computeJD / computeYMD.
julianday('2000-01-01') == 2451544.5 (iJD = 211_885_387_200_000).
Invalid inputs return nil exactly as SQLite returns NULL.

Public surface: date/1, time/1, datetime/1, julianday/1, unixepoch/1, strftime/1, timediff/1. Each receives the already-evaluated argument list (Elixir values).

Summary

date(args)

SQLite date(timestring, mod...)

datetime(args)

SQLite datetime(timestring, mod...)

julianday(args)

SQLite julianday(timestring, mod...)

strftime(arg1)

SQLite strftime(format, timestring, mod...)

time(args)

SQLite time(timestring, mod...)

timediff(arg1)

SQLite timediff(a, b)

unixepoch(args)