Functions/Database & utility/julian
Database & utility Scalar

julian()

Extract the Julian Day number from a date or timestamp

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 1.5.5-rc3 · In your browser

Engine example · Run to view results.