julian()

Extract the Julian Day number from a date or timestamp

Reference: DuckDB 1.3.2

Arguments & returns

3 overloads

julian(ts)

Scalar
Overload link ts Returns
#01 DATE DOUBLE
#02 TIMESTAMP DOUBLE
#03 TIMESTAMP WITH TIME ZONE DOUBLE

Example

julian example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.