MeridianMERIDIAN

Day of Week Name

datetime.component.day_of_week

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

Use it

Shell
finetype infer -i 'Monday' --mode column
# → datetime.component.day_of_week
DuckDB
SELECT ft_infer('Monday');
-- → 'datetime.component.day_of_week'
Cast template: {col} is your column
{col}
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
Per-locale rule
AR7 values, e.g. الاثنين, الثلاثاء, الأربعاء
BG7 values, e.g. понеделник, вторник, сряда
CS7 values, e.g. pondělí, úterý, středa
DA7 values, e.g. mandag, tirsdag, onsdag
DE7 values, e.g. Montag, Dienstag, Mittwoch
EL7 values, e.g. Δευτέρα, Τρίτη, Τετάρτη
EN14 values, e.g. Monday, Tuesday, Wednesday
ES7 values, e.g. lunes, martes, miércoles
ET7 values, e.g. esmaspäev, teisipäev, kolmapäev
FI7 values, e.g. maanantaina, tiistaina, keskiviikkona
FR7 values, e.g. lundi, mardi, mercredi
HR7 values, e.g. ponedjeljak, utorak, srijeda
HU7 values, e.g. hétfő, kedd, szerda
IT7 values, e.g. lunedì, martedì, mercoledì
LT7 values, e.g. pirmadienis, antradienis, trečiadienis
LV7 values, e.g. pirmdiena, otrdiena, trešdiena
NL7 values, e.g. maandag, dinsdag, woensdag
NO7 values, e.g. mandag, tirsdag, onsdag
PL7 values, e.g. poniedziałek, wtorek, środa
PT7 values, e.g. domingo, segunda-feira, terça-feira
RO7 values, e.g. luni, marți, miercuri
RU7 values, e.g. понедельник, вторник, среда
SK7 values, e.g. pondelok, utorok, streda
SL7 values, e.g. ponedeljek, torek, sreda
SV7 values, e.g. måndag, tisdag, onsdag
TR7 values, e.g. Pazartesi, Salı, Çarşamba
UK7 values, e.g. понеділок, вівторок, середа

Background

Origin

In a vast number of languages, the names of the seven days of the week are derived from the names of the seven classical planets.[1] The classical planets were in turn named after Hellenistic deities.[1] The Romance languages, except Portuguese and Mirandese, preserved the Latin planetary names, apart from Sunday and Saturday.[1] The Slavic, Baltic and Uralic languages, except Finnish and partially Estonian and Võro, adopted numbered day names that take Monday as the first day.[1] In the international standard ISO 8601, Monday is treated as the first day of the week, but in many countries it is counted as the second day.[1]

The Unicode Common Locale Data Repository's date specification, LDML Part 4, identifies weekday names with short strings rather than numbers, since there is no universally accepted numeric designation.[2] LDML Part 4 lets a day name vary by width: wide, abbreviated, short or narrow.[2] LDML Part 4 also lets a day name vary by context: the format form used within a complete date, or the stand-alone form used on its own, as in calendar headers.[2]

Use

Python's datetime documentation warns that, because locale-dependent formats depend on the current locale, care should be taken when making assumptions about the output value.[3] PostgreSQL's to_char writes the Day pattern as a full capitalised day name blank-padded to 9 characters.[4] PostgreSQL's FM prefix suppresses the trailing blanks that make a pattern's output fixed-width.[4] PostgreSQL's TM prefix gives localised day names based on lc_time.[4] In Excel, the formula =TEXT(TODAY(),"DDDD") returns today's day of the week, like Monday.[5]

PostgreSQL's D pattern numbers the days from Sunday (1) to Saturday (7), and its ID pattern gives the ISO 8601 day of the week from Monday (1) to Sunday (7).[4]

Check which language the names are in before parsing, and expect grammatical forms that differ from the dictionary form in some languages. (Meridian's view)

Sources

  1. [1]Names of the days of the weeksecondary source
  2. [2]Unicode Locale Data Markup Language (LDML) Part 4: Datesstandard
  3. [3]datetime — Basic date and time typesdocumentation
  4. [4]PostgreSQL: Documentation: 18: 9.8. Data Type Formatting Functionsdocumentation
  5. [5]TEXT functiondocumentation

How it's detected

Enum shown is EN only — each locale has its own enum.

Schema

https://meridian.online/schemas/datetime.component.day_of_week · Frictionless type string

finetype taxonomy datetime.component.day_of_week -o json-schema

Type Registry