SQL · Date and time functions

julianday()

The Julian day number. Subtract two values to get a difference in days.

sqlRunnable example sql course

Syntax

julianday(timestring)

Example

Open in the lab

SELECT julianday('2026-11-08') - julianday('2026-11-01') AS days;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.