add remove split language show hidden hide
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
NumSundays
5
336 rows affected
336 rows affected
Dt EndOfMonth LastSunday SundaysInMonth
2024-01-01 2024-01-31 2024-01-28 4
2024-02-01 2024-02-29 2024-02-25 4
2024-03-01 2024-03-31 2024-03-31 5
2024-04-01 2024-04-30 2024-04-28 4
2024-05-01 2024-05-31 2024-05-26 4
2024-06-01 2024-06-30 2024-06-30 5
2024-07-01 2024-07-31 2024-07-28 4
2024-08-01 2024-08-31 2024-08-25 4
2024-09-01 2024-09-30 2024-09-29 5
2024-10-01 2024-10-31 2024-10-27 4
2024-11-01 2024-11-30 2024-11-24 4
2024-12-01 2024-12-31 2024-12-29 5
2025-01-01 2025-01-31 2025-01-26 4
2025-02-01 2025-02-28 2025-02-23 4
2025-03-01 2025-03-31 2025-03-30 5
2025-04-01 2025-04-30 2025-04-27 4
2025-05-01 2025-05-31 2025-05-25 4
2025-06-01 2025-06-30 2025-06-29 5
2025-07-01 2025-07-31 2025-07-27 4
2025-08-01 2025-08-31 2025-08-31 5
2025-09-01 2025-09-30 2025-09-28 4
2025-10-01 2025-10-31 2025-10-26 4
2025-11-01 2025-11-30 2025-11-30 5
2025-12-01 2025-12-31 2025-12-28 4
2026-01-01 2026-01-31 2026-01-25 4
2026-02-01 2026-02-28 2026-02-22 4
2026-03-01 2026-03-31 2026-03-29 5
2026-04-01 2026-04-30 2026-04-26 4
2026-05-01 2026-05-31 2026-05-31 5
2026-06-01 2026-06-30 2026-06-28 4
2026-07-01 2026-07-31 2026-07-26 4
2026-08-01 2026-08-31 2026-08-30 5
2026-09-01 2026-09-30 2026-09-27 4
2026-10-01 2026-10-31 2026-10-25 4
2026-11-01 2026-11-30 2026-11-29 5
2026-12-01 2026-12-31 2026-12-27 4
2027-01-01 2027-01-31 2027-01-31 5
2027-02-01 2027-02-28 2027-02-28 4
2027-03-01 2027-03-31 2027-03-28 4
2027-04-01 2027-04-30 2027-04-25 4
2027-05-01 2027-05-31 2027-05-30 5
2027-06-01 2027-06-30 2027-06-27 4
2027-07-01 2027-07-31 2027-07-25 4
2027-08-01 2027-08-31 2027-08-29 5
2027-09-01 2027-09-30 2027-09-26 4
2027-10-01 2027-10-31 2027-10-31 5
2027-11-01 2027-11-30 2027-11-28 4
2027-12-01 2027-12-31 2027-12-26 4
2028-01-01 2028-01-31 2028-01-30 5
2028-02-01 2028-02-29 2028-02-27 4
2028-03-01 2028-03-31 2028-03-26 4
2028-04-01 2028-04-30 2028-04-30 5
2028-05-01 2028-05-31 2028-05-28 4
2028-06-01 2028-06-30 2028-06-25 4
2028-07-01 2028-07-31 2028-07-30 5
2028-08-01 2028-08-31 2028-08-27 4
2028-09-01 2028-09-30 2028-09-24 4
2028-10-01 2028-10-31 2028-10-29 5
2028-11-01 2028-11-30 2028-11-26 4
2028-12-01 2028-12-31 2028-12-31 5
2029-01-01 2029-01-31 2029-01-28 4
2029-02-01 2029-02-28 2029-02-25 4
2029-03-01 2029-03-31 2029-03-25 4
2029-04-01 2029-04-30 2029-04-29 5
2029-05-01 2029-05-31 2029-05-27 4
2029-06-01 2029-06-30 2029-06-24 4
2029-07-01 2029-07-31 2029-07-29 5
2029-08-01 2029-08-31 2029-08-26 4
2029-09-01 2029-09-30 2029-09-30 5
2029-10-01 2029-10-31 2029-10-28 4
2029-11-01 2029-11-30 2029-11-25 4
2029-12-01 2029-12-31 2029-12-30 5
2030-01-01 2030-01-31 2030-01-27 4
2030-02-01 2030-02-28 2030-02-24 4
2030-03-01 2030-03-31 2030-03-31 5
2030-04-01 2030-04-30 2030-04-28 4
2030-05-01 2030-05-31 2030-05-26 4
2030-06-01 2030-06-30 2030-06-30 5
2030-07-01 2030-07-31 2030-07-28 4
2030-08-01 2030-08-31 2030-08-25 4
2030-09-01 2030-09-30 2030-09-29 5
2030-10-01 2030-10-31 2030-10-27 4
2030-11-01 2030-11-30 2030-11-24 4
2030-12-01 2030-12-31 2030-12-29 5
2031-01-01 2031-01-31 2031-01-26 4
2031-02-01 2031-02-28 2031-02-23 4
2031-03-01 2031-03-31 2031-03-30 5
2031-04-01 2031-04-30 2031-04-27 4
2031-05-01 2031-05-31 2031-05-25 4
2031-06-01 2031-06-30 2031-06-29 5
2031-07-01 2031-07-31 2031-07-27 4
2031-08-01 2031-08-31 2031-08-31 5
2031-09-01 2031-09-30 2031-09-28 4
2031-10-01 2031-10-31 2031-10-26 4
2031-11-01 2031-11-30 2031-11-30 5
2031-12-01 2031-12-31 2031-12-28 4
2032-01-01 2032-01-31 2032-01-25 4
2032-02-01 2032-02-29 2032-02-29 5
2032-03-01 2032-03-31 2032-03-28 4
2032-04-01 2032-04-30 2032-04-25 4
2032-05-01 2032-05-31 2032-05-30 5
2032-06-01 2032-06-30 2032-06-27 4
2032-07-01 2032-07-31 2032-07-25 4
2032-08-01 2032-08-31 2032-08-29 5
2032-09-01 2032-09-30 2032-09-26 4
2032-10-01 2032-10-31 2032-10-31 5
2032-11-01 2032-11-30 2032-11-28 4
2032-12-01 2032-12-31 2032-12-26 4
2033-01-01 2033-01-31 2033-01-30 5
2033-02-01 2033-02-28 2033-02-27 4
2033-03-01 2033-03-31 2033-03-27 4
2033-04-01 2033-04-30 2033-04-24 4
2033-05-01 2033-05-31 2033-05-29 5
2033-06-01 2033-06-30 2033-06-26 4
2033-07-01 2033-07-31 2033-07-31 5
2033-08-01 2033-08-31 2033-08-28 4
2033-09-01 2033-09-30 2033-09-25 4
2033-10-01 2033-10-31 2033-10-30 5
2033-11-01 2033-11-30 2033-11-27 4
2033-12-01 2033-12-31 2033-12-25 4
2034-01-01 2034-01-31 2034-01-29 5
2034-02-01 2034-02-28 2034-02-26 4
2034-03-01 2034-03-31 2034-03-26 4
2034-04-01 2034-04-30 2034-04-30 5
2034-05-01 2034-05-31 2034-05-28 4
2034-06-01 2034-06-30 2034-06-25 4
2034-07-01 2034-07-31 2034-07-30 5
2034-08-01 2034-08-31 2034-08-27 4
2034-09-01 2034-09-30 2034-09-24 4
2034-10-01 2034-10-31 2034-10-29 5
2034-11-01 2034-11-30 2034-11-26 4
2034-12-01 2034-12-31 2034-12-31 5
2035-01-01 2035-01-31 2035-01-28 4
2035-02-01 2035-02-28 2035-02-25 4
2035-03-01 2035-03-31 2035-03-25 4
2035-04-01 2035-04-30 2035-04-29 5
2035-05-01 2035-05-31 2035-05-27 4
2035-06-01 2035-06-30 2035-06-24 4
2035-07-01 2035-07-31 2035-07-29 5
2035-08-01 2035-08-31 2035-08-26 4
2035-09-01 2035-09-30 2035-09-30 5
2035-10-01 2035-10-31 2035-10-28 4
2035-11-01 2035-11-30 2035-11-25 4
2035-12-01 2035-12-31 2035-12-30 5
2036-01-01 2036-01-31 2036-01-27 4
2036-02-01 2036-02-29 2036-02-24 4
2036-03-01 2036-03-31 2036-03-30 5
2036-04-01 2036-04-30 2036-04-27 4
2036-05-01 2036-05-31 2036-05-25 4
2036-06-01 2036-06-30 2036-06-29 5
2036-07-01 2036-07-31 2036-07-27 4
2036-08-01 2036-08-31 2036-08-31 5
2036-09-01 2036-09-30 2036-09-28 4
2036-10-01 2036-10-31 2036-10-26 4
2036-11-01 2036-11-30 2036-11-30 5
2036-12-01 2036-12-31 2036-12-28 4
2037-01-01 2037-01-31 2037-01-25 4
2037-02-01 2037-02-28 2037-02-22 4
2037-03-01 2037-03-31 2037-03-29 5
2037-04-01 2037-04-30 2037-04-26 4
2037-05-01 2037-05-31 2037-05-31 5
2037-06-01 2037-06-30 2037-06-28 4
2037-07-01 2037-07-31 2037-07-26 4
2037-08-01 2037-08-31 2037-08-30 5
2037-09-01 2037-09-30 2037-09-27 4
2037-10-01 2037-10-31 2037-10-25 4
2037-11-01 2037-11-30 2037-11-29 5
2037-12-01 2037-12-31 2037-12-27 4
2038-01-01 2038-01-31 2038-01-31 5
2038-02-01 2038-02-28 2038-02-28 4
2038-03-01 2038-03-31 2038-03-28 4
2038-04-01 2038-04-30 2038-04-25 4
2038-05-01 2038-05-31 2038-05-30 5
2038-06-01 2038-06-30 2038-06-27 4
2038-07-01 2038-07-31 2038-07-25 4
2038-08-01 2038-08-31 2038-08-29 5
2038-09-01 2038-09-30 2038-09-26 4
2038-10-01 2038-10-31 2038-10-31 5
2038-11-01 2038-11-30 2038-11-28 4
2038-12-01 2038-12-31 2038-12-26 4
2039-01-01 2039-01-31 2039-01-30 5
2039-02-01 2039-02-28 2039-02-27 4
2039-03-01 2039-03-31 2039-03-27 4
2039-04-01 2039-04-30 2039-04-24 4
2039-05-01 2039-05-31 2039-05-29 5
2039-06-01 2039-06-30 2039-06-26 4
2039-07-01 2039-07-31 2039-07-31 5
2039-08-01 2039-08-31 2039-08-28 4
2039-09-01 2039-09-30 2039-09-25 4
2039-10-01 2039-10-31 2039-10-30 5
2039-11-01 2039-11-30 2039-11-27 4
2039-12-01 2039-12-31 2039-12-25 4
2040-01-01 2040-01-31 2040-01-29 5
2040-02-01 2040-02-29 2040-02-26 4
2040-03-01 2040-03-31 2040-03-25 4
2040-04-01 2040-04-30 2040-04-29 5
2040-05-01 2040-05-31 2040-05-27 4
2040-06-01 2040-06-30 2040-06-24 4
2040-07-01 2040-07-31 2040-07-29 5
2040-08-01 2040-08-31 2040-08-26 4
2040-09-01 2040-09-30 2040-09-30 5
2040-10-01 2040-10-31 2040-10-28 4
2040-11-01 2040-11-30 2040-11-25 4
2040-12-01 2040-12-31 2040-12-30 5
2041-01-01 2041-01-31 2041-01-27 4
2041-02-01 2041-02-28 2041-02-24 4
2041-03-01 2041-03-31 2041-03-31 5
2041-04-01 2041-04-30 2041-04-28 4
2041-05-01 2041-05-31 2041-05-26 4
2041-06-01 2041-06-30 2041-06-30 5
2041-07-01 2041-07-31 2041-07-28 4
2041-08-01 2041-08-31 2041-08-25 4
2041-09-01 2041-09-30 2041-09-29 5
2041-10-01 2041-10-31 2041-10-27 4
2041-11-01 2041-11-30 2041-11-24 4
2041-12-01 2041-12-31 2041-12-29 5
2042-01-01 2042-01-31 2042-01-26 4
2042-02-01 2042-02-28 2042-02-23 4
2042-03-01 2042-03-31 2042-03-30 5
2042-04-01 2042-04-30 2042-04-27 4
2042-05-01 2042-05-31 2042-05-25 4
2042-06-01 2042-06-30 2042-06-29 5
2042-07-01 2042-07-31 2042-07-27 4
2042-08-01 2042-08-31 2042-08-31 5
2042-09-01 2042-09-30 2042-09-28 4
2042-10-01 2042-10-31 2042-10-26 4
2042-11-01 2042-11-30 2042-11-30 5
2042-12-01 2042-12-31 2042-12-28 4
2043-01-01 2043-01-31 2043-01-25 4
2043-02-01 2043-02-28 2043-02-22 4
2043-03-01 2043-03-31 2043-03-29 5
2043-04-01 2043-04-30 2043-04-26 4
2043-05-01 2043-05-31 2043-05-31 5
2043-06-01 2043-06-30 2043-06-28 4
2043-07-01 2043-07-31 2043-07-26 4
2043-08-01 2043-08-31 2043-08-30 5
2043-09-01 2043-09-30 2043-09-27 4
2043-10-01 2043-10-31 2043-10-25 4
2043-11-01 2043-11-30 2043-11-29 5
2043-12-01 2043-12-31 2043-12-27 4
2044-01-01 2044-01-31 2044-01-31 5
2044-02-01 2044-02-29 2044-02-28 4
2044-03-01 2044-03-31 2044-03-27 4
2044-04-01 2044-04-30 2044-04-24 4
2044-05-01 2044-05-31 2044-05-29 5
2044-06-01 2044-06-30 2044-06-26 4
2044-07-01 2044-07-31 2044-07-31 5
2044-08-01 2044-08-31 2044-08-28 4
2044-09-01 2044-09-30 2044-09-25 4
2044-10-01 2044-10-31 2044-10-30 5
2044-11-01 2044-11-30 2044-11-27 4
2044-12-01 2044-12-31 2044-12-25 4
2045-01-01 2045-01-31 2045-01-29 5
2045-02-01 2045-02-28 2045-02-26 4
2045-03-01 2045-03-31 2045-03-26 4
2045-04-01 2045-04-30 2045-04-30 5
2045-05-01 2045-05-31 2045-05-28 4
2045-06-01 2045-06-30 2045-06-25 4
2045-07-01 2045-07-31 2045-07-30 5
2045-08-01 2045-08-31 2045-08-27 4
2045-09-01 2045-09-30 2045-09-24 4
2045-10-01 2045-10-31 2045-10-29 5
2045-11-01 2045-11-30 2045-11-26 4
2045-12-01 2045-12-31 2045-12-31 5
2046-01-01 2046-01-31 2046-01-28 4
2046-02-01 2046-02-28 2046-02-25 4
2046-03-01 2046-03-31 2046-03-25 4
2046-04-01 2046-04-30 2046-04-29 5
2046-05-01 2046-05-31 2046-05-27 4
2046-06-01 2046-06-30 2046-06-24 4
2046-07-01 2046-07-31 2046-07-29 5
2046-08-01 2046-08-31 2046-08-26 4
2046-09-01 2046-09-30 2046-09-30 5
2046-10-01 2046-10-31 2046-10-28 4
2046-11-01 2046-11-30 2046-11-25 4
2046-12-01 2046-12-31 2046-12-30 5
2047-01-01 2047-01-31 2047-01-27 4
2047-02-01 2047-02-28 2047-02-24 4
2047-03-01 2047-03-31 2047-03-31 5
2047-04-01 2047-04-30 2047-04-28 4
2047-05-01 2047-05-31 2047-05-26 4
2047-06-01 2047-06-30 2047-06-30 5
2047-07-01 2047-07-31 2047-07-28 4
2047-08-01 2047-08-31 2047-08-25 4
2047-09-01 2047-09-30 2047-09-29 5
2047-10-01 2047-10-31 2047-10-27 4
2047-11-01 2047-11-30 2047-11-24 4
2047-12-01 2047-12-31 2047-12-29 5
2048-01-01 2048-01-31 2048-01-26 4
2048-02-01 2048-02-29 2048-02-23 4
2048-03-01 2048-03-31 2048-03-29 5
2048-04-01 2048-04-30 2048-04-26 4
2048-05-01 2048-05-31 2048-05-31 5
2048-06-01 2048-06-30 2048-06-28 4
2048-07-01 2048-07-31 2048-07-26 4
2048-08-01 2048-08-31 2048-08-30 5
2048-09-01 2048-09-30 2048-09-27 4
2048-10-01 2048-10-31 2048-10-25 4
2048-11-01 2048-11-30 2048-11-29 5
2048-12-01 2048-12-31 2048-12-27 4
2049-01-01 2049-01-31 2049-01-31 5
2049-02-01 2049-02-28 2049-02-28 4
2049-03-01 2049-03-31 2049-03-28 4
2049-04-01 2049-04-30 2049-04-25 4
2049-05-01 2049-05-31 2049-05-30 5
2049-06-01 2049-06-30 2049-06-27 4
2049-07-01 2049-07-31 2049-07-25 4
2049-08-01 2049-08-31 2049-08-29 5
2049-09-01 2049-09-30 2049-09-26 4
2049-10-01 2049-10-31 2049-10-31 5
2049-11-01 2049-11-30 2049-11-28 4
2049-12-01 2049-12-31 2049-12-26 4
2050-01-01 2050-01-31 2050-01-30 5
2050-02-01 2050-02-28 2050-02-27 4
2050-03-01 2050-03-31 2050-03-27 4
2050-04-01 2050-04-30 2050-04-24 4
2050-05-01 2050-05-31 2050-05-29 5
2050-06-01 2050-06-30 2050-06-26 4
2050-07-01 2050-07-31 2050-07-31 5
2050-08-01 2050-08-31 2050-08-28 4
2050-09-01 2050-09-30 2050-09-25 4
2050-10-01 2050-10-31 2050-10-30 5
2050-11-01 2050-11-30 2050-11-27 4
2050-12-01 2050-12-31 2050-12-25 4
2051-01-01 2051-01-31 2051-01-29 5
2051-02-01 2051-02-28 2051-02-26 4
2051-03-01 2051-03-31 2051-03-26 4
2051-04-01 2051-04-30 2051-04-30 5
2051-05-01 2051-05-31 2051-05-28 4
2051-06-01 2051-06-30 2051-06-25 4
2051-07-01 2051-07-31 2051-07-30 5
2051-08-01 2051-08-31 2051-08-27 4
2051-09-01 2051-09-30 2051-09-24 4
2051-10-01 2051-10-31 2051-10-29 5
2051-11-01 2051-11-30 2051-11-26 4
2051-12-01 2051-12-31 2051-12-31 5