建立公农历对照计算表 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)
标签:insert,sys,yearid,dataint,lunar,date From: https://www.cnblogs.com/easybi/p/17887093.html