公农历对照计算表 sys_date_lunar

发布时间 2023-12-08 14:26:49作者: EasyBI
建立公农历对照计算表 sys_date_lunar

 

 

create table sys_date_lunar([yearid] int ,[dataint] int)
insert into [sys_date_lunar] ([yearid],[dataint])  values (1900, 19416) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1901, 19168) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1902, 42352) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1903, 21717) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1904, 53856) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1905, 55632) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1906, 91476) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1907, 22176) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1908, 39632) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1909, 21970) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1910, 19168) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1911, 42422) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1912, 42192) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1913, 53840) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1914, 119381) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1915, 46400) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1916, 54944) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1917, 44450) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1918, 38320) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1919, 84343) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1920, 18800) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1921, 42160) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1922, 46261) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1923, 27216) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1924, 27968) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1925, 109396) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1926, 11104) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1927, 38256) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1928, 21234) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1929, 18800) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1930, 25958) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1931, 54432) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1932, 59984) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1933, 28309) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1934, 23248) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1935, 11104) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1936, 100067) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1937, 37600) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1938, 116951) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1939, 51536) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1940, 54432) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1941, 120998) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1942, 46416) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1943, 22176) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1944, 107956) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1945, 9680) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1946, 37584) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1947, 53938) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1948, 43344) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1949, 46423) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1950, 27808) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1951, 46416) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1952, 86869) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1953, 19872) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1954, 42448) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1955, 83315) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1956, 21200) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1957, 43432) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1958, 59728) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1959, 27296) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1960, 44710) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1961, 43856) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1962, 19296) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1963, 43748) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1964, 42352) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1965, 21088) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1966, 62051) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1967, 55632) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1968, 23383) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1969, 22176) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1970, 38608) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1971, 19925) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1972, 19152) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1973, 42192) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1974, 54484) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1975, 53840) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1976, 54616) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1977, 46400) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1978, 46496) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1979, 103846) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1980, 38320) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1981, 18864) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1982, 43380) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1983, 42160) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1984, 45690) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1985, 27216) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1986, 27968) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1987, 44870) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1988, 43872) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1989, 38256) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1990, 19189) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1991, 18800) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1992, 25776) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1993, 29859) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1994, 59984) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1995, 27480) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1996, 21952) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1997, 43872) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1998, 38613) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (1999, 37600) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2000, 51552) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2001, 55636) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2002, 54432) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2003, 55888) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2004, 30034) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2005, 22176) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2006, 43959) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2007, 9680) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2008, 37584) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2009, 51893) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2010, 43344) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2011, 46240) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2012, 47780) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2013, 44368) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2014, 21977) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2015, 19360) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2016, 42416) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2017, 86390) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2018, 21168) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2019, 43312) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2020, 31060) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2021, 27296) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2022, 44368) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2023, 23378) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2024, 19296) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2025, 42726) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2026, 42208) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2027, 53856) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2028, 60005) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2029, 54576) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2030, 23200) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2031, 30371) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2032, 38608) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2033, 19415) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2034, 19152) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2035, 42192) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2036, 118966) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2037, 53840) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2038, 54560) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2039, 56645) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2040, 46496) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2041, 22224) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2042, 21938) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2043, 18864) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2044, 42359) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2045, 42160) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2046, 43600) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2047, 111189) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2048, 27936) 
insert into [sys_date_lunar] ([yearid],[dataint])  values (2049, 44448)