sql-tests/inputs/datetime-formatting-invalid.sql

0001 --- TESTS FOR DATETIME FORMATTING FUNCTIONS WITH INVALID PATTERNS ---
0002
0003 -- separating this from datetime-formatting.sql, because the text form
0004 -- for patterns with 5 letters in SimpleDateFormat varies from different JDKs
0005 select date_format('2018-11-17 13:33:33.333', 'GGGGG');
0006 -- pattern letter count can not be greater than 10
0007 select date_format('2018-11-17 13:33:33.333', 'yyyyyyyyyyy');
0008 -- q/L in JDK 8 will fail when the count is more than 2
0009 select date_format('2018-11-17 13:33:33.333', 'qqqqq');
0010 select date_format('2018-11-17 13:33:33.333', 'QQQQQ');
0011 select date_format('2018-11-17 13:33:33.333', 'MMMMM');
0012 select date_format('2018-11-17 13:33:33.333', 'LLLLL');
0013
0014 select date_format('2018-11-17 13:33:33.333', 'EEEEE');
0015 select date_format('2018-11-17 13:33:33.333', 'FF');
0016 select date_format('2018-11-17 13:33:33.333', 'ddd');
0017 -- DD is invalid if the day-of-year exceeds 100, but it becomes valid in Java 11
0018 -- select date_format('2018-11-17 13:33:33.333', 'DD');
0019 select date_format('2018-11-17 13:33:33.333', 'DDDD');
0020 select date_format('2018-11-17 13:33:33.333', 'HHH');
0021 select date_format('2018-11-17 13:33:33.333', 'hhh');
0022 select date_format('2018-11-17 13:33:33.333', 'kkk');
0023 select date_format('2018-11-17 13:33:33.333', 'KKK');
0024 select date_format('2018-11-17 13:33:33.333', 'mmm');
0025 select date_format('2018-11-17 13:33:33.333', 'sss');
0026 select date_format('2018-11-17 13:33:33.333', 'SSSSSSSSSS');
0027 select date_format('2018-11-17 13:33:33.333', 'aa');
0028 select date_format('2018-11-17 13:33:33.333', 'V');
0029 select date_format('2018-11-17 13:33:33.333', 'zzzzz');
0030 select date_format('2018-11-17 13:33:33.333', 'XXXXXX');
0031 select date_format('2018-11-17 13:33:33.333', 'ZZZZZZ');
0032 select date_format('2018-11-17 13:33:33.333', 'OO');
0033 select date_format('2018-11-17 13:33:33.333', 'xxxxxx');
0034
0035 select date_format('2018-11-17 13:33:33.333', 'A');
0036 select date_format('2018-11-17 13:33:33.333', 'n');
0037 select date_format('2018-11-17 13:33:33.333', 'N');
0038 select date_format('2018-11-17 13:33:33.333', 'p');
0039
0040 -- disabled week-based patterns
0041 select date_format('2018-11-17 13:33:33.333', 'Y');
0042 select date_format('2018-11-17 13:33:33.333', 'w');
0043 select date_format('2018-11-17 13:33:33.333', 'W');
0044 select date_format('2018-11-17 13:33:33.333', 'u');
0045 select date_format('2018-11-17 13:33:33.333', 'e');
0046 select date_format('2018-11-17 13:33:33.333', 'c');
0047
0048 -- others
0049 select date_format('2018-11-17 13:33:33.333', 'B');
0050 select date_format('2018-11-17 13:33:33.333', 'C');
0051 select date_format('2018-11-17 13:33:33.333', 'I');
0052
0053