auto

Applies the auto modifier, allowing SQLite to automatically convert between date/time text representations and Julian day numbers as needed.

This auto modifier is useful when comparing a text-based date/time value with a Julian day number. SQLite will attempt to convert the text to a Julian day number before performing the comparison. This behavior was introduced in SQLite version 3.16.0.

Example

// Compare a string date with a Julian day number
select(DATETIME("2451545.0").auto()).execute()

See also