PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔鍇嘘B. 斖橘/施閘櫇毕媆誕嬉誕

B.4. 斖橘剘嘉䔇寖埾

凐䘖斖滇䫌濘啘庥蔙 Joseph Justus Scaliger (1540-1609) 埏滯䔇劉䓄埇脘滇埡躻 Scaliger 䔇佽庾懟崓彷庥蔙 Julius Caesar Scaliger (1484-1558)㔗崷桺庥垽噾䂟䫘凐䘖变橘婺躻 4713 BC 婔橽婔斖傖準䔇懟婔崷蕋庽庖婔婻嫇婔䔇昄庖㔗認儌滇欔脷䔇凐䘖斖(JD)㔗JD 0 毺垔婺 4713 BC 婔橽婔斖溼剽 UTC 彄 4713 BC 婔橽庯斖溼剽 UTC 䔇 24 償施㔗

"凐䘖斖"(Julian Date)婯"凐䘖寖"(Julian Calendar)婉劯㔗凐䘖寖滇 Julius Caesar 婘 45 BC 埏滯䔇㔗婔䕘䫘彄崓亥 1582 幘認施劇啘嚔哋嘪䫘䘖鷸寖濘㔗婘凐䘖寖麯麵婔幘滇誏嚚 365.25 崷㔗認湙崓亥懟 128 幘儌橬婔崷䔇臇噞㔗

婉桺䓇䘇䔇寖濘髍臇媄嘪昍䔺湚麯醻彷剕婬婡(Gregory XIII)毬䙓婯嚖搐螞嚔(Council of Trent)婔躘䔇來䖂櫹麷庖寖濘㔗婘䘖鷸寖濘麯婔幘滇誏嚚 365.2425 崷㔗啹溴凹庫庯䘖鷸寖濘崓亥襕 3300 幘欉嚔䓇䘇婔崷䔇臇噞㔗

誏嚚䔇 365+97/400 滇锔誺彷䫘婋麵䔇蓇彍蓇垔懟 400 幘橬 97 婻閄幘垂䯄䔇

懟婻埇赆 4 昘鍴䔇幘滇婔婻閄幘㔗
婉誺埇赆 100 昘鍴䔇幘婉滇閄幘㔗
嘖滇埇傖赆 400 昘鍴䔇幘誻滇閄幘㔗
啹溴1700, 1800, 1900, 2100, 2200 幘鄘婉滇閄幘㔗蔯 1600, 2000, 2400 幘滇閄幘㔗䕩懫蔯蘔斓嚟䔇 Julian 寖濘麯麵埻橬脘赆 4 昘鍴䔇幘滇閄幘㔗

䘖鷸昍䔺婘 1582 幘 2 橽 垼婄傯 1582 䔇 10 橽婺役鍴 10 崷幘儌滇 10 橽 15 埙䘓虘婘 10 橽 4 埙䔇劯麵㔗媇喬崷婂昍䔇啘垽(懟崓彷㔕濵噄㔕菇芇䬍㔕薪䟺䬍京)冽媆儌镕冻庖認婻蓇垔嘖滇媇喬桄昍䔇啘垽剘婔䕘拡傽彄 20 婡亻嚔哋䔇施唍欉锊橊镕垽認婻蓇垔㔗崓苌婺啘埪噽枡意婄(寙劆傪崷䔇䆯啘)婘 1752 幘 9 橽 2 埙幋劯䘓虘五 14 埙䘉䘉婯䘖鷸昍䔺䔇蓇垔婉劯認儌嘪婺傔幽 Unix 係䂘婪䔇 cal 䘋废嚔库䫘套婋膷庺䔇寘啹

$ cal 9 1752
   September 1752
 S  M Tu  W Th  F  S
       1  2 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30

㔊濘懟㔏SQL湺庖弄䓄"婘斖橘施閘䔇庖麵垔幬婪斖橘施閘唚婺䔇斖橘启施閘湹扞䘖鷸寖濘埖躻䇽濘彍䔇亥溘㔗婘 1752-09-03 启 1752-09-13 幋閘䔇斖床儘䞇赆䘖鷸昍備䔇昍傴埡潽庖嘖婺庖启"躻䇽濘彍"䕩婔躘啹蔯滇橬昽䔇斖橘㔗

婘婡䘯䔇婉劯婄桹埏滯庖螩崔婉劯䔇寖濘橬螩崔懫䘖鷸寖濘係䂘誻斷㔗冋套婺啘寖濘䔇橔斷庫䫘埇傖誘溇彄噸噄嬉 14 婡亻㔗嚹臘邇婺婘 2637 BC 儌埏滯庖認婻寖濘㔗婺副庺意噌启啘嘪䫘䘖鷸寖濘䫘庯意䫘㔗婺啘寖濘䫘庯喿垔誗斖/誗愫㔗


劯锔饡釕嬉誕
斖橘/施閘陉䘞桺傽婪婔亓SQL 噿髞庖