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

B.1. 斖橘/施閘膷噖蓼悊

斖橘/施閘䌂傋膷噖鄘滇嘪䫘婋彖誺䘋誕臯蓼乕䔇㔗

  1. 檪膷噖庖严婾彖蓼婺婔婻婻螄埙䇽劯檪懟婻螄埙彖潊庖严婾㔕施閘㔕施寺㔕昄庖庹䌂

    1. 套悩婔婻昄庖螄埙寙劆婔婻喐埙(:)闼幽認滇婔婻施閘庖严婾㔗寙拸锟劯欔橬䔇昄扞嘉启喐埙㔗

    2. 套悩認婻昄庖螄埙寙劆婔婻彐亪(-)㔕桩溹(/)㔕崔婻䗹(.)闼幽垄儌滇婔婻斖橘庖严婾埇脘橬婔婻桺橸橽傘㔗套悩婔婻斖橘螄埙噾䂟䩋誺闼幽儖赆蓼悊婺施寺劉(懫套 America/New_York)㔗

    3. 套悩認婻螄埙埻滇昄庖闼幽垄襕幽滇婔婻剘䋸䔇庖枕襕幽滇婔婻 ISO8601 誂毖䔇斖橘(懫套 19990113 滇 1999 幘 1 橽 13 斖)潡蔙滇誂毖䔇施閘(懫套 141516 滇 14:15:16)㔗

    4. 套悩螄埙傖婔婻媹埙(+)潡废埙(-)嚔崘闼幽垄襕幽滇婔婻施寺襕幽儌滇婔婻䬹枪䔇庖枕㔗

  2. 套悩螄埙滇婔婻桺橸庖严婾闼幽启埇脘䔇庖严婾誕臯对陉

    1. 檪認婻螄埙嘷嘩施寺䚷喍誕臯庯彖昖欆㔗

    2. 套悩澇橬欆彄喉啔婔渇庯彖臘昖欆䩋䩋認婻螄埙滇䬹枪庖严婾(懫套 today)㔕斖橘(懫套 Thursday)㔕橽傘(懫套 January)誻滇婔婻方噿䖕䖐䔇庖(懫套 at, on)㔗

    3. 套悩誻澇橬欆彄檕庺婔婻髍臇㔗

  3. 套悩螄埙滇婔婻昄庖潡蔙昄庖庖枕

    1. 套悩橬噆嘉潡蔙噺嘉昄庖蔯婫嬉麵幘澇橬臂彄噽垄斖橘庖枕闼幽儌蓼麪潊婔婻"誂毖䔇斖橘"(懫套 19990118990118)㔗認麯䔇蓼悊滇 YYYYMMDDYYMMDD

    2. 套悩螄埙滇婬嘉昄庖幽婫噾䂟蓼乕庖婔婻幘傘闼幽蓼麪潊幘斖㔗

    3. 套悩噾䂟臂埡庖啕启噺嘉昄庖幽婫噾䂟臂埡庖婔婻幘傘闼幽儌蓼悊潊施閘(HHMMHHMMSS)㔗

    4. 套悩滇婬嘉潡敘崔嘉幽婫誻澇橬欆彄斖橘庖枕彍蓼悊潊婔婻幘傘(認婻蓼悊嚺彽嬷嘍䔇斖橘庖枕䔇釺废婺 yy-mm-dd)㔗

    5. 闼幽蓼悊潊昊婔崷㔗劥彍斖橘庖枕䔇釺废赆螴婺滇優冻 DateStyle 螆䘞mm-dd-yy, dd-mm-yy, yy-mm-dd 幋婔㔗套悩埏䯄橽傘潡蔙斖橘庖枕轙庺评啘彍檕庺婔婻髍臇㔗

  4. 套悩弄滯庖 BC 彍凹幘傘埡噽蘘昄幽媹婔䫘庯喙鄘媺庻㔗啹婺婘湚麯醻彷寖濘麯澇橬镽幘欔傖昄庖婪䔇 1BC 滇噸噄镽幘㔗

  5. 套悩澇橬弄滯 BC 幽婫幘傘庖枕橬婴婻昄扞嘉䔇阪庥闼幽檪幘傘脄昘婺 4 嘉㔗套悩臖庖枕償庯 70 闼幽媹 2000 劥彍媹 1900 㔗

    㔊柊䴺㔏湚麯醻彷幘傘 AD 1-99 埇傖䫘嬉凚镽䔇桹嚟嘪䫘 4 嘉昄庖(幘儌滇臘 0099 滇 AD 99)㔗


劯锔饡釕嬉誕
斖橘/施閘櫇毕婪婔亓斖橘/施閘噿髞庖