Meridianmeridian

Day of Week Name

datetime.component.day_of_week

Full weekday name. Locale-specific (Monday vs lundi vs Montag).

Domain
datetime
Category
component
Casts to
VARCHAR
Scope
Locale-specific
Locales
EN, FR, DE, ES, IT, PT, AR, BG, CS, DA, EL, ET, FI, HR, HU, LT, LV, NL, NO, PL, RO, RU, SK, SL, SV, TR, UK

Try it

CLI
$ finetype infer -i "Monday"
→ datetime.component.day_of_week

DuckDB

Detect
SELECT finetype('Monday');
-- → 'datetime.component.day_of_week'
Cast expression
{col}
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'datetime.component.day_of_week';

JSON Schema

finetype schema datetime.component.day_of_week
{
  "$id": "https://meridian.online/schemas/datetime.component.day_of_week",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Full weekday name. Locale-specific (Monday vs lundi vs Montag).",
  "enum": [
    "Monday",
    "Tuesday",
    "Wednesday",
    "Thursday",
    "Friday",
    "Saturday",
    "Sunday"
  ],
  "examples": [
    "Monday",
    "Friday",
    "Sunday"
  ],
  "title": "Day of Week Name",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "{col}"
}

Examples

MondayFridaySunday