Skip to content

Glossary: SQL Beyond the Basics

julianday

Also written: julianday()

A SQLite function that turns a date into a day number, so julianday(a) - julianday(b) counts the days between two dates. If either date is NULL, so is the result.

Where the book teaches it

Related terms

date()strftime