Checking supported features...
MariaDB Version 12.3.0-MariaDB-asan-debug
 - SSL connections supported
 - binaries are debug compiled
 - binaries built with wsrep patch
Collecting tests...
Installing system database...
worker[01] Using MTR_BUILD_THREAD 300, with reserved ports 19000..19029

==============================================================================

TEST                                      RESULT   TIME (ms) or COMMENT
--------------------------------------------------------------------------

bug.to_date_sql                          [ fail ]
        Test ended at 2026-02-07 15:27:56

CURRENT_TEST: bug.to_date_sql
--- /share8t/bld/preview-12.3/bb-12.3-MDEV-19683-to_date-asan/mysql-test/suite/bug/to_date_sql.result	2026-02-07 15:11:29.881438374 +0200
+++ /share8t/bld/preview-12.3/bb-12.3-MDEV-19683-to_date-asan/mysql-test/suite/bug/to_date_sql.reject	2026-02-07 15:27:56.539224969 +0200
@@ -0,0 +1,896 @@
+SET NAMES utf8mb4;
+CREATE TABLE dates (dt DATE, purpose VARCHAR(32));
+INSERT INTO dates VALUES
+('2026-01-01', 'Jan, Thu'),
+('2026-02-01', 'Feb, Sun'),
+('2026-03-01', 'Mar, Sun'),
+('2026-04-01', 'Apr, Wed'),
+('2026-05-01', 'May, Fri'),
+('2026-06-01', 'Jun, Mon'),
+('2026-07-01', 'Jul, Wed'),
+('2026-08-01', 'Aug, Sat'),
+('2026-09-01', 'Sep, Tue'),
+('2026-10-01', 'Oct, Thu'),
+('2026-11-01', 'Nov, Sun'),
+('2026-12-01', 'Dec, Tue')
+;
+CREATE TABLE lc_nls (lc CHAR(5), nls CHAR(32));
+INSERT INTO lc_nls VALUES
+('sq_AL', 'ALBANIAN'),
+('en_US', 'AMERICAN'),
+('ar_YE', 'ARABIC'),
+('eu_ES', 'BASQUE'),
+('be_BY', 'BELARUSIAN'),
+('pt_BR', 'BRAZILIAN PORTUGUESE'),
+('bg_BG', 'BULGARIAN'),
+('fr_FR', 'CANADIAN FRENCH'),
+('ca_ES', 'CATALAN'),
+('hr_HR', 'CROATIAN'),
+('sr_RS', 'CYRILLIC SERBIAN'),
+('cs_CZ', 'CZECH'),
+('da_DK', 'DANISH'),
+('nl_BE', 'DUTCH'),
+('en_GB', 'ENGLISH'),
+('et_EE', 'ESTONIAN'),
+('fi_FI', 'FINNISH'),
+('fr_BE', 'FRENCH'),
+('de_DE', 'GERMAN'),
+('el_GR', 'GREEK'),
+('he_IL', 'HEBREW'),
+('hi_IN', 'HINDI'),
+('hu_HU', 'HUNGARIAN'),
+('is_IS', 'ICELANDIC'),
+('id_ID', 'INDONESIAN'),
+('it_IT', 'ITALIAN'),
+('ja_JP', 'JAPANESE'),
+('en_CA', 'KANNADA'),
+('ko_KR', 'KOREAN'),
+('es_ES', 'LATIN AMERICAN SPANISH'),
+('lv_LV', 'LATVIAN'),
+('lt_LT', 'LITHUANIAN'),
+('mk_MK', 'MACEDONIAN'),
+('ms_MY', 'MALAY'),
+('es_MX', 'MEXICAN SPANISH'),
+('nb_NO', 'NORWEGIAN'),
+('pl_PL', 'POLISH'),
+('pt_PT', 'PORTUGUESE'),
+('ro_RO', 'ROMANIAN'),
+('ru_RU', 'RUSSIAN'),
+('zh_CN', 'SIMPLIFIED CHINESE'),
+('sk_SK', 'SLOVAK'),
+('sl_SI', 'SLOVENIAN'),
+('es_ES', 'SPANISH'),
+('sw_KE', 'SWAHILI'),
+('sv_SE', 'SWEDISH'),
+('ta_IN', 'TAMIL'),
+('th_TH', 'THAI'),
+('zh_CN', 'TRADITIONAL CHINESE'),
+('tr_TR', 'TURKISH'),
+('uk_UA', 'UKRAINIAN'),
+('vi_VN', 'VIETNAMESE')
+;
+CREATE PROCEDURE names()
+BEGIN
+DECLARE loc CHAR(5);
+DECLARE lang VARCHAR(32);
+DECLARE no_data BOOL DEFAULT FALSE;
+DECLARE stmt TEXT;
+DECLARE fmt_long_month VARCHAR(32) DEFAULT 'MONTH DD, YYYY';
+DECLARE fmt_short_month VARCHAR(32) DEFAULT 'MON DD, YYYY';
+DECLARE fmt_long_day VARCHAR(32) DEFAULT 'YYYY-MM-DD, DAY';
+DECLARE fmt_short_day VARCHAR(32) DEFAULT 'YYYY-MM-DD, DY';
+DECLARE ln CURSOR FOR SELECT lc, nls FROM lc_nls ORDER BY nls;
+DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_data = TRUE;
+OPEN ln;
+fetch_loop: LOOP
+FETCH ln INTO loc, lang;
+IF no_data THEN
+LEAVE fetch_loop;
+END IF;
+SELECT CONCAT("SET STATEMENT lc_time_names = ",loc," FOR ",
+"SELECT dt, purpose, "
+        "TO_DATE(TO_CHAR(dt,'",fmt_long_month,"'),'",fmt_long_month,
+"','NLS_DATE_LANGUAGE=''",lang,"''') AS long_month, ",
+"DATE(TO_DATE(TO_CHAR(dt,'",fmt_long_month,"'),'",fmt_long_month,
+"','NLS_DATE_LANGUAGE=''",lang,"''')) = dt AS long_month_correct, ",
+"TO_DATE(TO_CHAR(dt,'",fmt_short_month,"'),'",fmt_short_month,
+"','NLS_DATE_LANGUAGE=''",lang,"''') AS short_month, ",
+"DATE(TO_DATE(TO_CHAR(dt,'",fmt_short_month,"'),'",fmt_short_month,
+"','NLS_DATE_LANGUAGE=''",lang,"''')) = dt AS short_month_correct, ",
+"TO_DATE(TO_CHAR(dt,'",fmt_long_day,"'),'",fmt_long_day,
+"','NLS_DATE_LANGUAGE=''",lang,"''') AS long_day, ",
+"DATE(TO_DATE(TO_CHAR(dt,'",fmt_long_day,"'),'",fmt_long_day,
+"','NLS_DATE_LANGUAGE=''",lang,"''')) = dt AS long_day_correct, ",
+"TO_DATE(TO_CHAR(dt,'",fmt_short_day,"'),'",fmt_short_day,
+"','NLS_DATE_LANGUAGE=''",lang,"''') AS short_day_correct, ",
+"DATE(TO_DATE(TO_CHAR(dt,'",fmt_short_day,"'),'",fmt_short_day,
+"','NLS_DATE_LANGUAGE=''",lang,"''')) = dt AS short_day_correct ",
+"FROM dates") INTO stmt;
+SELECT stmt;
+EXECUTE IMMEDIATE stmt;
+END LOOP;
+CLOSE ln;
+END $
+CALL names();
+stmt
+SET STATEMENT lc_time_names = sq_AL FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ALBANIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ALBANIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ALBANIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ALBANIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ALBANIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ALBANIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ALBANIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ALBANIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = en_US FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''AMERICAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''AMERICAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''AMERICAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''AMERICAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''AMERICAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''AMERICAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''AMERICAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''AMERICAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ar_YE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ARABIC''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ARABIC''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ARABIC''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ARABIC''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ARABIC''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ARABIC''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ARABIC''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ARABIC''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = eu_ES FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BASQUE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BASQUE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BASQUE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BASQUE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BASQUE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BASQUE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BASQUE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BASQUE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = be_BY FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BELARUSIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BELARUSIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BELARUSIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BELARUSIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BELARUSIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BELARUSIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BELARUSIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BELARUSIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = pt_BR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BRAZILIAN PORTUGUESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = bg_BG FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BULGARIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''BULGARIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BULGARIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''BULGARIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BULGARIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''BULGARIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BULGARIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''BULGARIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = fr_FR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CANADIAN FRENCH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ca_ES FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CATALAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CATALAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CATALAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CATALAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CATALAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CATALAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CATALAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CATALAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = hr_HR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CROATIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CROATIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CROATIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CROATIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CROATIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CROATIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CROATIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CROATIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = sr_RS FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CYRILLIC SERBIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = cs_CZ FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CZECH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''CZECH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CZECH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''CZECH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CZECH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''CZECH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CZECH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''CZECH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = da_DK FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''DANISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''DANISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''DANISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''DANISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''DANISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''DANISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''DANISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''DANISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = nl_BE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''DUTCH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''DUTCH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''DUTCH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''DUTCH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''DUTCH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''DUTCH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''DUTCH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''DUTCH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = en_GB FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ENGLISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ENGLISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ENGLISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ENGLISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ENGLISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ENGLISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ENGLISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ENGLISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = et_EE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ESTONIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ESTONIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ESTONIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ESTONIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ESTONIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ESTONIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ESTONIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ESTONIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = fi_FI FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''FINNISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''FINNISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''FINNISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''FINNISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''FINNISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''FINNISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''FINNISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''FINNISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = fr_BE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''FRENCH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''FRENCH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''FRENCH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''FRENCH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''FRENCH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''FRENCH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''FRENCH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''FRENCH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = de_DE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''GERMAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''GERMAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''GERMAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''GERMAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''GERMAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''GERMAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''GERMAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''GERMAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = el_GR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''GREEK''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''GREEK''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''GREEK''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''GREEK''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''GREEK''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''GREEK''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''GREEK''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''GREEK''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = he_IL FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HEBREW''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HEBREW''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HEBREW''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HEBREW''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HEBREW''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HEBREW''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HEBREW''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HEBREW''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = hi_IN FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HINDI''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HINDI''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HINDI''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HINDI''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HINDI''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HINDI''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HINDI''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HINDI''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = hu_HU FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HUNGARIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''HUNGARIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HUNGARIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''HUNGARIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HUNGARIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''HUNGARIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HUNGARIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''HUNGARIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = is_IS FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ICELANDIC''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ICELANDIC''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ICELANDIC''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ICELANDIC''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ICELANDIC''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ICELANDIC''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ICELANDIC''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ICELANDIC''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = id_ID FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''INDONESIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''INDONESIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''INDONESIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''INDONESIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''INDONESIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''INDONESIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''INDONESIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''INDONESIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = it_IT FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ITALIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ITALIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ITALIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ITALIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ITALIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ITALIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ITALIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ITALIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ja_JP FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''JAPANESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''JAPANESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''JAPANESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''JAPANESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''JAPANESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''JAPANESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''JAPANESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''JAPANESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	NULL	NULL	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	NULL	NULL	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	NULL	NULL	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = en_CA FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''KANNADA''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''KANNADA''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''KANNADA''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''KANNADA''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''KANNADA''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''KANNADA''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''KANNADA''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''KANNADA''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ko_KR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''KOREAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''KOREAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''KOREAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''KOREAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''KOREAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''KOREAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''KOREAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''KOREAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	NULL	NULL	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	NULL	NULL	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	NULL	NULL	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = es_ES FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LATIN AMERICAN SPANISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = lv_LV FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LATVIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LATVIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LATVIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LATVIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LATVIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LATVIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LATVIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LATVIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = lt_LT FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LITHUANIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''LITHUANIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LITHUANIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''LITHUANIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LITHUANIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''LITHUANIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LITHUANIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''LITHUANIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = mk_MK FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MACEDONIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MACEDONIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MACEDONIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MACEDONIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MACEDONIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MACEDONIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MACEDONIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MACEDONIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ms_MY FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MALAY''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MALAY''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MALAY''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MALAY''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MALAY''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MALAY''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MALAY''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MALAY''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = es_MX FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''MEXICAN SPANISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = nb_NO FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''NORWEGIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''NORWEGIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''NORWEGIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''NORWEGIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''NORWEGIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''NORWEGIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''NORWEGIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''NORWEGIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = pl_PL FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''POLISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''POLISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''POLISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''POLISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''POLISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''POLISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''POLISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''POLISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = pt_PT FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''PORTUGUESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''PORTUGUESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''PORTUGUESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''PORTUGUESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''PORTUGUESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''PORTUGUESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''PORTUGUESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''PORTUGUESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ro_RO FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ROMANIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''ROMANIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ROMANIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''ROMANIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ROMANIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''ROMANIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ROMANIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''ROMANIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ru_RU FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''RUSSIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''RUSSIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''RUSSIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''RUSSIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''RUSSIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''RUSSIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''RUSSIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''RUSSIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = zh_CN FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SIMPLIFIED CHINESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	NULL	NULL	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	NULL	NULL	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	NULL	NULL	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = sk_SK FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SLOVAK''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SLOVAK''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SLOVAK''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SLOVAK''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SLOVAK''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SLOVAK''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SLOVAK''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SLOVAK''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	NULL	NULL
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	NULL	NULL
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	NULL	NULL
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	NULL	NULL
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = sl_SI FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SLOVENIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SLOVENIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SLOVENIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SLOVENIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SLOVENIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SLOVENIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SLOVENIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SLOVENIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = es_ES FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SPANISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SPANISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SPANISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SPANISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SPANISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SPANISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SPANISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SPANISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = sw_KE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SWAHILI''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SWAHILI''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SWAHILI''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SWAHILI''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SWAHILI''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SWAHILI''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SWAHILI''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SWAHILI''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = sv_SE FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SWEDISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''SWEDISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SWEDISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''SWEDISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SWEDISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''SWEDISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SWEDISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''SWEDISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = ta_IN FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TAMIL''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TAMIL''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TAMIL''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TAMIL''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TAMIL''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TAMIL''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TAMIL''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TAMIL''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	NULL	NULL
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	NULL	NULL
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	NULL	NULL
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	NULL	NULL
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	NULL	NULL
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	NULL	NULL
+stmt
+SET STATEMENT lc_time_names = th_TH FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''THAI''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''THAI''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''THAI''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''THAI''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''THAI''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''THAI''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''THAI''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''THAI''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	NULL	NULL	2026-04-01 00:00:00	1	NULL	NULL
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	NULL	NULL	2026-07-01 00:00:00	1	NULL	NULL
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	NULL	NULL	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1	NULL	NULL
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	NULL	NULL	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	NULL	NULL	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	NULL	NULL	2026-12-01 00:00:00	1	NULL	NULL
+stmt
+SET STATEMENT lc_time_names = zh_CN FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TRADITIONAL CHINESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	NULL	NULL	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	NULL	NULL	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	NULL	NULL	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	NULL	NULL	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = tr_TR FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TURKISH''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''TURKISH''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TURKISH''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''TURKISH''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TURKISH''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''TURKISH''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TURKISH''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''TURKISH''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	NULL	NULL	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	NULL	NULL	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	NULL	NULL	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = uk_UA FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''UKRAINIAN''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''UKRAINIAN''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''UKRAINIAN''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''UKRAINIAN''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''UKRAINIAN''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''UKRAINIAN''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''UKRAINIAN''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''UKRAINIAN''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	NULL	NULL	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1	2026-12-01 00:00:00	1
+stmt
+SET STATEMENT lc_time_names = vi_VN FOR SELECT dt, purpose, TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''VIETNAMESE''') AS long_month, DATE(TO_DATE(TO_CHAR(dt,'MONTH DD, YYYY'),'MONTH DD, YYYY','NLS_DATE_LANGUAGE=''VIETNAMESE''')) = dt AS long_month_correct, TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''VIETNAMESE''') AS short_month, DATE(TO_DATE(TO_CHAR(dt,'MON DD, YYYY'),'MON DD, YYYY','NLS_DATE_LANGUAGE=''VIETNAMESE''')) = dt AS short_month_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''VIETNAMESE''') AS long_day, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DAY'),'YYYY-MM-DD, DAY','NLS_DATE_LANGUAGE=''VIETNAMESE''')) = dt AS long_day_correct, TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''VIETNAMESE''') AS short_day_correct, DATE(TO_DATE(TO_CHAR(dt,'YYYY-MM-DD, DY'),'YYYY-MM-DD, DY','NLS_DATE_LANGUAGE=''VIETNAMESE''')) = dt AS short_day_correct FROM dates
+dt	purpose	long_month	long_month_correct	short_month	short_month_correct	long_day	long_day_correct	short_day_correct	short_day_correct
+2026-01-01	Jan, Thu	2026-01-01 00:00:00	1	NULL	NULL	2026-01-01 00:00:00	1	2026-01-01 00:00:00	1
+2026-02-01	Feb, Sun	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1	2026-02-01 00:00:00	1
+2026-03-01	Mar, Sun	NULL	NULL	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1	2026-03-01 00:00:00	1
+2026-04-01	Apr, Wed	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1	2026-04-01 00:00:00	1
+2026-05-01	May, Fri	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1	2026-05-01 00:00:00	1
+2026-06-01	Jun, Mon	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1	2026-06-01 00:00:00	1
+2026-07-01	Jul, Wed	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1	2026-07-01 00:00:00	1
+2026-08-01	Aug, Sat	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1	2026-08-01 00:00:00	1
+2026-09-01	Sep, Tue	2026-09-01 00:00:00	1	2026-09-01 00:00:00	1	NULL	NULL	2026-09-01 00:00:00	1
+2026-10-01	Oct, Thu	NULL	NULL	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1	2026-10-01 00:00:00	1
+2026-11-01	Nov, Sun	NULL	NULL	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1	2026-11-01 00:00:00	1
+2026-12-01	Dec, Tue	NULL	NULL	2026-12-01 00:00:00	1	NULL	NULL	2026-12-01 00:00:00	1
+DROP PROCEDURE names;
+DROP TABLE lc_nls, dates;

Result length mismatch

 - saving '/share8t/bld/preview-12.3/bb-12.3-MDEV-19683-to_date-asan/mysql-test/var/log/bug.to_date_sql/' to '/share8t/bld/preview-12.3/bb-12.3-MDEV-19683-to_date-asan/mysql-test/var/log/bug.to_date_sql/'
--------------------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 2 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): bug.to_date_sql

The log files in var/log may give you some hint of what went wrong.

If you want to report this error, MariaDB's bug tracker is found at
https://jira.mariadb.org

mysql-test-run: *** ERROR: there were failing test cases