Skip to content

Julian Date

Type Registry

Julian Date

datetime.date.julian

Short-form Julian date with 2-digit year and 3-digit day-of-year. Common in manufacturing, logistics, and food expiration dates.

Domain datetime›date
Casts to DATE
Scope Universal

Try it

CLI 
$ finetype infer -i "24-015"
→ datetime.date.julian

DuckDB

Detect 
SELECT finetype('24-015');
-- → 'datetime.date.julian'
Cast expression

No direct cast expression — use finetype_cast() for normalisation.

Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS DATE) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'datetime.date.julian';

JSON Schema

finetype schema datetime.date.julian 
{
  "$id": "https://noon.sh/schemas/datetime.date.julian",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Short-form Julian date with 2-digit year and 3-digit day-of-year. Common in manufacturing, logistics, and food expiration dates.",
  "examples": [
    "24-015",
    "23-365"
  ],
  "maxLength": 6,
  "minLength": 6,
  "pattern": "^\\d{2}-\\d{3}$",
  "title": "Julian Date",
  "type": "string"
}

Examples

24-01523-365

Types in datetime