| PostgreSQL 9.2.4文鐃緒申 | ||||
|---|---|---|---|---|
| 鐃緒申鐃塾ペ￥申鐃緒申 | 鐃緒申鐃緒申鐃緒申 | 鐃緒申 8鐃熟デ￥申鐃緒申鐃緒申 | 鐃緒申鐃塾ペ￥申鐃緒申 | |
PostgreSQL鐃叔は￥申表8-9鐃祝種申鐃緒申鐃緒申討鐃緒申鐃�SQL鐃緒申鐃緒申鐃春と誌申鐃緒申如鐃緒申鐃緒申鐃緒申里鐃緒申戮討鐃緒申鐃緒申檗鐃緒申箸鐃緒申鐃銃わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃塾デ￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃術でわ申鐃緒申藥誌申劼砲弔鐃緒申討鐃�鐃緒申9.9鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃曙ゴ鐃所オ鐃緒申導鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃叔�鐃叔わ申鐃獣てわ申鐃�鐃緒申B.4鐃緒申鐃夙）￥申鐃緒申鐃春はワ申鐃曙ゴ鐃所オ鐃緒申砲鐃緒申鐃緒申鐃緒申辰瞳彁鐃緒申鐃緒申鐃殉わ申鐃緒申
表 8-9. 鐃緒申鐃緒申/鐃緒申鐃緒申如鐃緒申鐃緒申鐃�
| 鐃緒申名 | 鐃緒申納鐃緒申鐃緒申鐃緒申 | 鐃緒申鐃緒申 | 鐃叔縁申硫鐃緒申 | 鐃叔縁申鐃縮わ申鐃� | 鐃緒申鐃緒申 |
|---|---|---|---|---|---|
| timestamp [ (p) ] [ without time zone ] | 8 鐃出ワ申鐃緒申 | 鐃緒申鐃春と誌申鐃緒申両鐃緒申鐃淑誌申鐃緒申鐃俊なわ申鐃緒申 | 4713 BC | 294276 AD | 1鐃緒申鐃獣￥申14鐃緒申 |
| timestamp [ (p) ] with time zone | 8鐃出ワ申鐃緒申 | 鐃緒申鐃春と誌申鐃緒申両鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃春わ申 | 4713 BC | 294276 AD | 1鐃緒申鐃獣￥申14鐃緒申 |
| date | 4鐃出ワ申鐃緒申 | 鐃緒申鐃春（誌申鐃緒申覆鐃緒申鐃� | 4713 BC | 5874897 AD | 1鐃緒申 |
| time [ (p) ] [ without time zone ] | 8鐃出ワ申鐃緒申 | 鐃緒申鐃緒申鐃緒申鐃緒申佞覆鐃緒申鐃� | 00:00:00 | 24:00:00 | 1鐃緒申鐃獣￥申14鐃緒申 |
| time [ (p) ] with time zone | 12鐃出ワ申鐃緒申 | 鐃緒申鐃緒申鐃緒申鐃塾誌申鐃緒申里漾鐃緒申鐃緒申鐃緒申鐃緒申佞鐃� | 00:00:00+1459 | 24:00:00-1459 | 1鐃緒申鐃獣￥申14鐃緒申 |
| interval [ fields ] [ (p) ] | 12鐃出ワ申鐃緒申 | 鐃緒申鐃瞬間鰹申 | -178000000年 | 178000000年 | 1鐃緒申鐃獣￥申14鐃緒申 |
鐃緒申鐃緒申: 標鐃緒申SQL鐃叔は￥申単鐃淑わ申timestamp鐃夙わ申鐃緒申鐃緒申鐃述わ申timestamp without time zone鐃緒申同鐃緒申鐃叔わ申鐃暑こ鐃夙わ申鐃竣求し鐃殉わ申鐃緒申 PostgreSQL鐃熟わ申鐃緒申暴爐醐申泙鐃緒申鐃� 鐃緒申7.3鐃緒申鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃�timestamp with time zone鐃夙わ申鐃銃逸申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申timestamp with time zone鐃緒申timestamptz鐃夙常申略鐃緒申鐃暑こ鐃夙わ申鐃緒申鐃銃わ申鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申PostgreSQL鐃夙種申鐃塾鰹申張鐃叔わ申鐃緒申
time鐃緒申timestamp鐃緒申鐃緒申鐃�interval鐃緒申鐃獣フワ申鐃緒申鐃緒申匹鐃緒申鐃粛�鐃緒申鐃緒申討鐃緒申訃�鐃緒申鐃緒申鐃淑駕申鐃塾件申鐃緒申鐃緒申鐃所す鐃暑オ鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃粛でわ申鐃緒申p鐃緒申鐃緒申鐃緒申佞鐃緒申泙鐃緒申鐃� 鐃叔フワ申鐃緒申箸任蓮鐃緒申鐃緒申鐃重�鐃緒申鐃緒申鐃駿わ申鐃出わ申鐃緒申続鐃緒申呂鐃緒申鐃殉わ申鐃緒申 p鐃塾居申鐃緒申鐃熟囲わ申timestamp鐃緒申鐃緒申interval鐃緒申鐃塾常申鐃緒申0鐃緒申鐃緒申6鐃叔わ申鐃緒申
鐃緒申鐃緒申: timestamp鐃緒申鐃粛わ申8鐃出ワ申鐃緒申鐃緒申鐃緒申鐃淑醐申鐃淳のデフワ申鐃緒申函砲燃鐃叔種申鐃緒申鐃銃わ申鐃緒申弌鐃緒申鐃緒申戮討鐃緒申佑砲弔鐃緒申豆鐃緒申鐃緒申鐃緒申戮鐃粛�鐃緒申鐃叔わ申鐃緒申 timestamp鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申鐃緒申動鐃緒申鐃緒申鐃緒申鐃緒申鐃淑常申鐃緒申離鐃緒申檗鐃緒申箸鐃緒申歉擇鐃緒申鐃淑わ申鐃緒申鐃緒申僖鐃緒申鐃緒申鐃塾ワ申鐃竣ワ申鐃緒申鐃祝で鰹申納鐃緒申鐃緒申討鐃緒申鐃夙￥申有鐃緒申鐃緒申鐃緒申鐃駿わ申6鐃緒申蠑�鐃緒申鐃緒申鐃緒申鐃盾し鐃緒申泙鐃緒申鐃� timestamp鐃緒申鐃粛わ申2000-01-01鐃緒申鐃緒申鐃緒申鐃祝わ申鐃緒申鐃出駕申鐃獣随申鐃夙わ申鐃銃鰹申納鐃緒申鐃緒申泙鐃緒申鐃� timestamp鐃緒申鐃粛わ申鐃緒申動鐃緒申鐃緒申鐃緒申鐃緒申鐃夙わ申鐃銃鰹申納鐃緒申鐃緒申討鐃緒申鐃出￥申2000-01-01鐃緒申鐃緒申鐃叔�鐃緒申鐃熟囲で�鐃緒申鐃緒申鐃緒申戮鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃塾ッ�鐃緒申鐃緒申鐃緒申鐃緒申戮鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申動鐃緒申鐃緒申鐃緒申datetimes鐃緒申鐃緒申僂鐃緒申鐃夙常申納鐃緒申鐃緒申鐃緒申楼呂鐃所広鐃緒申timestamp鐃緒申鐃粛￥申4713 BC鐃緒申鐃緒申5874897 AD鐃殉で）わ申認鐃緒申鐃緒申泙鐃緒申鐃�
同鐃緒申鐃緒申鐃緒申僖鐃緒申鐃緒申鐃緒申鐃竣ワ申鐃緒申鐃緒申time鐃緒申鐃緒申鐃�interval鐃緒申鐃粛わ申鐃緒申動鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申8鐃出ワ申鐃緒申鐃緒申鐃緒申鐃塾わ申鐃緒申鐃曙か鐃祝わ申辰導鐃叔種申鐃緒申鐃暑か鐃緒申鐃緒申蠅件申泙鐃緒申鐃� 鐃緒申動鐃緒申鐃緒申鐃緒申鐃塾常申隋�鐃順き鐃緒申interval鐃叔は間隔わ申鐃緒申鐃獣わ申鐃緒申櫃鐃緒申鐃緒申戮鐃緒申鐃緒申鐃殉わ申鐃緒申
time鐃緒申鐃緒申8鐃出ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃術わ申鐃曙た鐃緒申鐃祝は￥申p鐃緒申0鐃緒申鐃緒申6鐃殉でわ申鐃熟囲で誌申鐃術駕申能鐃叔わ申鐃緒申 鐃殉わ申鐃緒申鐃緒申動鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃術わ申鐃緒申鐃緒申鐃祝わ申0鐃緒申鐃緒申10鐃殉でわ申鐃緒申鐃術駕申能鐃叔わ申鐃緒申
interval鐃叔￥申鐃緒申鐃緒申鐃祝わ申鐃宿加のワ申鐃竣ワ申鐃緒申鵑�わ申鐃所、鐃淑駕申鐃塾ｏ申鐃縦の醐申鐃緒申鐃緒申僂鐃緒申導鐃叔種申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃宿の緒申鐃緒申鐃緒申鐃緒申鵑靴泙鐃緒申鐃�
YEAR MONTH DAY HOUR MINUTE SECOND YEAR TO MONTH DAY TO HOUR DAY TO MINUTE DAY TO SECOND HOUR TO MINUTE HOUR TO SECOND MINUTE TO SECOND
鐃緒申鐃緒申 fields鐃緒申鐃緒申鐃�p鐃緒申鐃緒申鐃祝誌申鐃所さ鐃緒申鐃夙￥申鐃緒申鐃駿わ申鐃獣のみわ申適鐃術わ申鐃緒申鐃塾で￥申fields鐃緒申SECOND鐃緒申泙泙覆鐃緒申鐃出なわ申覆鐃緒申鐃緒申箸鐃緒申鐃緒申佞鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃�
time with time zone鐃緒申標鐃緒申SQL鐃緒申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃粛�鐃緒申鐃緒申鐃緒申鐃緒申襪刻申襪鰹申箸砲覆蠅�鐃粛なわ申鐃緒申鐃緒申鐃薯示わ申鐃銃わ申鐃殉わ申鐃緒申 鐃循とわ申匹両鐃順、date鐃緒申time鐃緒申timestamp without time zone鐃緒申timestamp with time zone鐃緒申鐃夙み刻申錣誌申如鐃緒申鐃緒申戮討離鐃緒申廛螢縁申鐃緒申鐃緒申鐃緒申鐃緒申弋瓩居申鐃緒申鐃緒申鐃緒申/鐃緒申鐃緒機能鐃緒申鐃駿てわ申鐃藷供わ申鐃銃わ申鐃緒申呂鐃緒申任鐃緒申鐃�
abstime鐃緒申reltime鐃緒申鐃緒申鐃駿わ申鐃純い鐃叔￥申鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃叔誌申鐃術わ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃塾件申鐃塾誌申鐃術わ申鐃薯けてわ申鐃緒申鐃緒申鐃緒申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申郎鐃緒申鐃塾ワ申蝓種申鐃緒申悩鐃緒申鐃緒申鐃緒申鐃緒申能鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃春と誌申鐃緒申鐃緒申鐃緒申呂蓮鐃�ISO 8601鐃緒申SQL鐃淳器申鐃緒申鐃緒申鐃緒申的鐃緒申POSTGRES鐃緒申鐃緒申鐃緒申他鐃緒申泙鐃循とわ申匹鐃重�鐃緒申鐃夙みなわ申鐃緒申鐃書式わ申鐃緒申鐃緒申佞鐃緒申泙鐃緒申鐃� 鐃緒申鐃春わ申鐃緒申鐃熟にわ申鐃緒申鐃緒申鐃緒申-鐃緒申-年鐃塾緒申鐃緒申里茲�鐃淑わ申鐃緒申鐃緒申箸鐃緒申瓩居申鐃暑い鐃緒申鐃縦わ申鐃塾書式につわ申鐃銃は￥申鐃緒申鐃緒申鐃塾フワ申鐃緒申鐃緒申匹鮃イ鐃緒申塀鐃緒申鐃祝誌申鐃緒申任鐃緒申鐃処う鐃祝なってわ申鐃殉わ申鐃緒申 DateStyle鐃術ワ申瓠種申鐃緒申鐃�MDY鐃緒申鐃緒申鐃所す鐃緒申弌鐃緒申鐃緒申鐃叔�鐃夙わ申鐃緒申鐃緒申撚鐃潤さ鐃曙、DMY鐃緒申鐃緒申鐃所す鐃緒申鐃緒申鐃緒申鐃叔�鐃夙わ申鐃緒申鐃緒申如鐃�YMD鐃緒申鐃緒申鐃所す鐃緒申鐃叔�鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申撚鐃潤さ鐃緒申泙鐃緒申鐃�
PostgreSQL鐃緒申鐃緒申鐃緒申/鐃緒申鐃緒申留鐃緒申僂砲鐃緒申鐃緒申鐃宿醐申鐃�SQL鐃緒申鐃竣居申鐃緒申鐃緒申鐃緒申任鐃緒申鐃� 鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申鐃緒申呂砲鐃緒申鐃緒申鐃緒申鐃緒申里聞鐃淑醐申鐃緒申狼鐃渋э申函鐃緒申遒�鐃緒申喀鐃緒申鐃緒申鐃緒申鐃緒申道鐃緒申鐃緒申咾鐃殉わ申鐃緒申儔鐃叔緒申淵謄鐃緒申鐃緒申肇侫鐃緒申鐃緒申鐃宿に関わ申鐃銃わ申鐃緒申録B鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申
鐃銃ワ申鐃緒申鐃緒申文鐃緒申鐃緒申里茲�鐃祝￥申鐃緒申鐃春わ申鐃緒申鐃緒申謄鐃緒申鐃獣縁申鐃緒申鐃緒申鐃緒申念呂鐃宿�鐃竣わ申鐃緒申鐃暑こ鐃夙わ申廚鐃緒申个鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃� 鐃旬細わ申鐃緒申4.1.2.7鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申 SQL鐃叔は駕申鐃緒申鐃塾刻申文鐃緒申必鐃竣でわ申鐃緒申
type [ (p) ] 'value'
鐃緒申鐃緒申鐃叔￥申p鐃緒申鐃獣フワ申鐃緒申鐃緒申匹両鐃緒申鐃緒申鐃緒申焚鐃緒申侶鐃緒申鐃緒申与鐃緒申鐃暑オ鐃竣ワ申鐃緒申鐃緒申鐃緒申鐃駿の誌申鐃緒申任鐃緒申鐃� 鐃緒申鐃駿わ申time鐃緒申timestamp鐃緒申鐃緒申鐃�interval鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申鐃緒申任鐃緒申泙鐃緒申鐃� 鐃粛の居申鐃緒申鐃熟囲は器申鐃緒申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃祝わ申鐃緒申鐃緒申鐃緒申鐃駿誌申鐃所が鐃淑わ申鐃緒申鐃熟￥申鐃叔フワ申鐃緒申箸離鐃銃ワ申鐃緒申佑鐃緒申鐃緒申戮砲覆鐃殉わ申鐃緒申
表8-10鐃緒申date鐃緒申鐃緒申鐃緒申鐃熟駕申能鐃淑わ申里琉鐃緒申鐃緒申鮗┐鐃緒申泙鐃緒申鐃�
表 8-10. 鐃緒申鐃緒申鐃緒申鐃緒申
| 鐃緒申 | 鐃緒申鐃緒申 |
|---|---|
| 1999-01-08 | ISO 8601鐃緒申鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申平箴�鐃書式）￥申 |
| January 8, 1999 | 鐃緒申鐃駿てわ申datestyle鐃緒申鐃熟モー鐃宿にわ申鐃緒申鐃緒申曖鐃醇さ鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� |
| 1/8/1999 | MDY鐃盾ー鐃宿でわ申1鐃緒申8鐃緒申鐃緒申DMY鐃盾ー鐃宿でわ申8鐃緒申1鐃緒申鐃緒申 |
| 1/18/1999 | MDY鐃盾ー鐃宿でわ申1鐃緒申18鐃緒申鐃緒申他鐃塾モー鐃宿では居申鐃巡さ鐃緒申泙鐃緒申鐃� |
| 01/02/03 | MDY鐃盾ー鐃宿でわ申2003年1鐃緒申2鐃緒申鐃緒申DMY鐃盾ー鐃宿でわ申2003年2鐃緒申1鐃緒申鐃緒申YMD鐃盾ー鐃宿でわ申2001年2鐃緒申3鐃緒申鐃緒申 |
| 1999-Jan-08 | 鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申鐃� |
| Jan-08-1999 | 鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申鐃� |
| 08-Jan-1999 | 鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申鐃� |
| 99-Jan-08 | YMD鐃盾ー鐃宿わ申1鐃緒申8鐃緒申鐃緒申他鐃塾モー鐃宿ではワ申鐃初ー鐃緒申 |
| 08-Jan-99 | 1鐃緒申8鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申YMD鐃盾ー鐃宿ではワ申鐃初ー鐃緒申 |
| Jan-08-99 | 1鐃緒申8鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申YMD鐃盾ー鐃宿ではワ申鐃初ー鐃緒申 |
| 19990108 | ISO 8601鐃緒申鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申鐃� |
| 990108 | ISO 8601鐃緒申鐃緒申鐃駿てのモー鐃宿わ申1鐃緒申8鐃緒申鐃祝なわ申泙鐃緒申鐃� |
| 1999.008 | 年鐃夙わ申鐃緒申鐃緒申鐃殉でわ申鐃淳件申 |
| J2451187 | 鐃緒申螢�鐃緒申鐃緒申 |
| January 8, 99 BC | 鐃緒申鐃書紀醐申鐃緒申99年 |
鐃緒申鐃緒申鐃緒申鐃緒申了鐃緒申鐃緒申表鐃緒申鐃緒申鐃緒申time [(p) ] without time zone鐃緒申time [ (p) ] with time zone鐃叔わ申鐃緒申 time単鐃夙でわ申time without time zone鐃緒申同鐃緒申鐃叔わ申鐃緒申
鐃緒申鐃緒申鐃塾件申鐃舜わ申有鐃緒申鐃緒申鐃緒申鐃熟は￥申鐃緒申鐃緒、鐃緒申鐃塾醐申縫鐃緒申廛鐃緒申鐃緒申濃鐃緒申鐃緒申咾鐃緒申鐃淑わ申泙鐃緒申鐃� 鐃緒申表8-11鐃緒申表8-12鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 time without time zone鐃舜わ申鐃緒申鐃熟に誌申鐃緒申鐃俊わ申鐃緒申鐃所さ鐃曙た鐃緒申隋�鐃緒申鐃緒申鐃俊は警刻申覆鐃縮居申襪居申鐃殉わ申鐃緒申 鐃殉わ申鐃緒申America/New_York鐃淑ど夏誌申鐃瞬居申則鐃緒申泙鐃緒申鐃緒申鐃緒申名鐃緒申鐃緒申僂鐃緒申討鐃緒申覆鐃緒申造蝓�鐃緒申鐃春わ申鐃緒申蠅刻申襪鰹申箸呂任鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申無鐃暑さ鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾常申隋�標鐃準か鐃銃誌申鐃瞬わ申鐃宿わ申鐃緒申鐃重�鐃術わ申鐃暑か鐃緒申鐃緒申鐃叔わ申鐃緒申茲�鐃祝￥申鐃緒申鐃春の誌申鐃所が必鐃竣でわ申鐃緒申 適鐃准な誌申鐃緒申鐃俊ワ申鐃春ワ申鐃獣トわ申time with time zone鐃緒申鐃緒申鐃粛に居申録鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃�
表 8-11. 鐃緒申鐃緒申鐃緒申鐃緒申
| 鐃緒申 | 鐃緒申鐃緒申 |
|---|---|
| 04:05:06.789 | ISO 8601 |
| 04:05:06 | ISO 8601 |
| 04:05 | ISO 8601 |
| 040506 | ISO 8601 |
| 04:05 AM | 04:05鐃緒申同鐃緒申鐃緒申AM鐃緒申鐃粛に影駈申鐃緒申与鐃緒申鐃淑わ申鐃緒申 |
| 04:05 PM | 16:05鐃緒申同鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟わ申12鐃淑駕申鐃叔なわ申鐃緒申个覆鐃殉わ申鐃緒申 |
| 04:05:06.789-8 | ISO 8601 |
| 04:05:06-08:00 | ISO 8601 |
| 04:05-08:00 | ISO 8601 |
| 040506-08 | ISO 8601 |
| 04:05:06 PST | 鐃緒申略鐃緒申鐃祝わ申鐃緒申鐃緒申鐃俊の誌申鐃所。 |
| 2003-04-12 04:05:06 America/New_York | 名鐃緒申鐃祝わ申鐃緒申鐃緒申鐃俊の誌申鐃所。 |
表 8-12. 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申
| 鐃緒申 | 鐃緒申鐃緒申 |
|---|---|
| PST | 鐃緒申略鐃緒申鐃緒申鐃銃刻申鐃緒申平鐃緒申標鐃緒申鐃緒申屐鐃� |
| America/New_York | 鐃緒申鐃緒申鐃淑誌申鐃緒申鐃緒申名 |
| PST8PDT | POSIX鐃書式わ申 time zone 鐃緒申鐃緒申 |
| -8:00 | ISO 8601鐃緒申PST鐃術のワ申鐃春ワ申鐃獣ワ申 |
| -800 | ISO 8601鐃緒申PST鐃術のワ申鐃春ワ申鐃獣ワ申 |
| -8 | ISO 8601鐃緒申PST鐃術のワ申鐃春ワ申鐃獣ワ申 |
| zulu | UTC鐃術の件申鐃緒申鐃緒申略鐃緒申 |
| z | zulu鐃緒申略鐃緒申 |
鐃緒申鐃緒申鐃俊の誌申鐃緒申鐃緒申法鐃祝関わ申鐃緒申楮戮鐃�鐃緒申8.5.3鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申
鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申弖鐃緒申悗鐃粛�鐃緒申鐃緒申鐃緒申鐃熟は￥申鐃緒申鐃春と誌申鐃緒申鐃熟�鐃暑し鐃緒申鐃緒申鐃緒申砲鐃緒申慮鐃祝ワ申鐃竣ワ申鐃緒申鐃叔誌申鐃緒申鐃俊￥申鐃緒申鐃塾醐申縫鐃緒申廛鐃緒申鐃緒申鐃�AD鐃盾し鐃緒申鐃緒申BC鐃緒申鐃緒申覆鐃殉わ申鐃緒申 鐃緒申他鐃緒申AD/BC鐃緒申鐃緒申鐃緒申咾鐃緒申鐃緒申鐃緒申佞鐃緒申鐃緒申鐃祝￥申發�鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃熟推奨鐃緒申鐃緒申鐃緒申鐃緒申任呂鐃緒申鐃殉わ申鐃藷。￥申 鐃緒申鐃緒申鐃緒申鐃獣て￥申
1999-01-08 04:05:06
鐃緒申
1999-01-08 04:05:06 -8:00
鐃緒申有鐃緒申鐃緒申鐃粛で￥申ISO 8601鐃祝緒申鬚靴討鐃緒申泙鐃緒申鐃� 鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃術わ申鐃緒申討鐃緒申鐃�
January 8 04:05:06 1999 PST
鐃夙わ申鐃緒申鐃書式もサ鐃楯￥申鐃夙わ申鐃緒申泙鐃緒申鐃�
標鐃緒申SQL鐃叔は￥申timestamp without time zone鐃塾ワ申謄鐃緒申鐃�timestamp with time zone鐃塾ワ申謄鐃緒申鐃�"+"鐃盾し鐃緒申鐃緒申"-"鐃緒申鐃緒申隼鐃緒申鐃塾醐申了鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申佞鐃緒申洞鐃緒申未鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾わ申鐃潤、標鐃緒申暴鐃緒申鐃緒申函鐃�
TIMESTAMP '2004-10-19 10:23:54'
鐃緒申timestamp without time zone鐃祝￥申
TIMESTAMP '2004-10-19 10:23:54+02'
鐃緒申timestamp with time zone鐃祝なわ申泙鐃緒申鐃� PostgreSQL鐃熟￥申鐃緒申鐃塾件申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃淑醐申鐃緒申鐃緒申謄鐃緒申鐃緒申鐃緒申討鮓‐擇鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾わ申鐃緒申鐃塾よう鐃緒申timestamp without time zone鐃薯扱わ申鐃殉わ申鐃緒申 鐃緒申謄鐃暑が鐃塾実わ申timestamp with time zone鐃夙わ申鐃銃逸申鐃緒申鐃緒申茲�鐃祝わ申鐃緒申砲蓮鐃緒申磴�鐃出￥申
TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'
鐃塾よう鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申的鐃淑件申鐃緒申鐃緒申蠅件申討鐃緒申鐃緒申鐃緒申鐃緒申鐃� timestamp without time zone鐃夙件申鐃緒申僂澆離鐃銃ワ申鐃叔は￥申PostgreSQL鐃熟警刻申覆鐃緒申鐃緒申鐃緒申咯鐃緒申鐃薯すべわ申無鐃暑し鐃殉わ申鐃緒申 鐃縦まり、鐃緒申未鐃緒申佑鐃緒申鐃緒申鐃緒申鐃緒申譴随申鐃緒申鐃緒申佑鐃緒申鐃緒申鐃�/鐃緒申鐃緒申侫鐃緒申鐃緒申鐃宿わ申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃俊わ申調鐃緒申鐃熟なわ申鐃緒申泙鐃緒申鐃�
timestamp with time zone鐃祝つわ申鐃緒申鐃緒申鐃緒申鐃祝鰹申納鐃緒申鐃緒申討鐃緒申鐃緒申佑肋鐃緒申UTC鐃叔わ申鐃淑駈申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃重�鐃祝ワ申鐃緒申縫奪鐃宿醐申鐃緒申GMT鐃夙わ申鐃緒申鐃塾わ申鐃銃わ申鐃殉わ申鐃祝￥申 鐃緒申鐃緒申鐃俊わ申鐃緒申鐃緒申的鐃祝誌申鐃所さ鐃曙た鐃緒申鐃緒申鐃粛は￥申鐃緒申鐃塾誌申鐃緒申鐃俊わ申適鐃緒申鐃緒申鐃緒申鐃春ワ申鐃獣トわ申鐃緒申僂鐃緒申鐃�UTC鐃緒申鐃術器申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申文鐃緒申鐃緒申忙鐃緒申鐃緒申咾鐃緒申鐃緒申蠅居申鐃銃わ申鐃淑わ申鐃緒申鐃熟￥申鐃緒申鐃緒申鐃銃ワ申鐃�TimeZone鐃術ワ申瓠種申鐃緒申房鐃緒申鐃緒申鐃銃わ申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃俊とみなわ申鐃曙、timezone鐃緒申鐃緒申鐃緒申鐃術のワ申鐃春ワ申鐃獣トわ申鐃緒申僂鐃緒申鐃�UTC鐃緒申鐃術器申鐃緒申鐃緒申泙鐃緒申鐃�
timestamp with time zone鐃粛わ申鐃緒申鐃熟わ申鐃緒申鐃夙￥申鐃緒申鐃緒申鐃粛わ申UTC鐃緒申鐃初現鐃峻わ申timezone鐃緒申鐃術器申鐃緒申鐃曙、鐃緒申鐃塾誌申鐃緒申鐃俊のワ申鐃緒申鐃緒申鐃緒申鐃緒申屬箸鐃緒申鐃宿緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 他鐃塾誌申鐃緒申鐃俊での誌申鐃瞬わ申表鐃緒申鐃緒申鐃緒申砲蓮鐃�timezone鐃緒申鐃術刻申鐃緒申鐃暑か鐃緒申鐃緒申鐃暑い鐃緒申AT TIME ZONE鐃緒申文鐃緒申鐃緒申9.9.3 鐃薯参照）わ申鐃緒申僂鐃緒申泙鐃緒申鐃�
timestamp without time zone鐃緒申timestamp with time zone鐃瞬わ申鐃術器申鐃叔は￥申鐃縮常申timestamp without time zone鐃粛わ申timezone鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申屬箸鐃緒申討澆覆鐃緒申鐃暑、鐃殉わ申鐃熟￥申鐃緒申鐃所さ鐃緒申鐃緒申里鐃緒申鐃緒申蠅居申鐃殉わ申鐃緒申 AT TIME ZONE鐃緒申鐃緒申僂鐃緒申鐃緒申儡鐃緒申任蓮鐃緒申曚覆鐃緒申鐃緒申鐃俊わ申鐃緒申鐃叔わ申鐃殉わ申鐃緒申
PostgreSQL鐃叔わ申鐃緒申鐃緒申鐃緒申鐃塾わ申鐃緒申法鐃�表8-13鐃祝種申鐃緒申鐃緒申討鐃緒申鐃処う鐃緒申鐃緒申鐃縮わ申鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申鐃緒申鐃粛をサポ￥申鐃夙わ申鐃銃わ申鐃殉わ申鐃緒申 infinity鐃緒申-infinity鐃緒申鐃粛は￥申鐃緒申鐃縮にワ申鐃緒申鐃銃ワ申鐃緒申鐃緒申鐃緒申表鐃緒申鐃緒申鐃曙、鐃術刻申鐃緒申鐃曙ず鐃緒申表鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 他鐃塾わ申里蓮鐃獣縁申亡鐃塾�鐃緒申鐃緒申鐃曙た表鐃緒申鐃叔￥申鐃宿み刻申鐃殉わ申鐃楯にわ申鐃縮常申鐃緒申鐃緒申鐃�/鐃緒申鐃緒申鐃粛わ申鐃術器申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃獣わ申now鐃夙わ申鐃塾器申連文鐃緒申鐃緒申鐃緒申匹濆鐃緒申泙鐃緒申箸鐃緒申鐃緒申砲鐃緒申了鐃緒申鐃緒申鐃緒申佑鐃緒申儡鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申 鐃緒申鐃緒申鐃緒申鐃粛はわ申鐃駿て￥申SQL鐃緒申鐃殉ワ申匹鐃緒申鐃緒申鐃夙わ申鐃銃使わ申鐃緒申鐃熟￥申単鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申覆鐃緒申鐃出なわ申泙鐃緒申鐃�
表 8-13. 鐃獣種申鐃緒申鐃緒申鐃�/鐃緒申鐃緒申鐃緒申鐃�
| 鐃緒申鐃緒申文鐃緒申鐃緒申 | 有鐃緒申鐃淑件申 | 鐃緒申鐃緒申 |
|---|---|---|
| epoch | date, timestamp | 1970-01-01 00:00:00+00鐃緒申Unix鐃緒申鐃緒申鐃銃ワ申鐃緒申屬砲鐃緒申鐃緒申襯種申鐃緒申鐃� |
| infinity | date, timestamp | 他鐃塾わ申鐃駿てのワ申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃所将鐃緒申 |
| -infinity | date, timestamp | 他鐃塾わ申鐃駿てのワ申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃緒申 |
| now | date, time, timestamp | 鐃緒申鐃夙ワ申鵐競鐃緒申鐃緒申鐃緒申粒鐃緒申六鐃緒申鐃� |
| today | date, timestamp | 鐃緒申鐃緒申鐃塾始まわ申 |
| tomorrow | date, timestamp | 鐃緒申鐃緒申鐃塾始まわ申 |
| yesterday | date, timestamp | 鐃緒申鐃緒申鐃塾始まわ申 |
| allballs | time | 00:00:00.00 UTC |
SQL鐃淳器申鐃塾関随申鐃叔わ申鐃暑、CURRENT_DATE鐃緒申CURRENT_TIME鐃緒申CURRENT_TIMESTAMP鐃緒申LOCALTIME鐃緒申LOCALTIMESTAMP鐃盾、鐃出縁申鐃緒申鐃緒申如鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申佞泙鐃緒申六鐃緒申屬鐃緒申佑箸鐃緒申道鐃緒申僂任鐃緒申泙鐃緒申鐃� 鐃緒申鐃�4鐃縦では￥申鐃緒申鐃竣ワ申鐃緒申鐃夙わ申鐃緒申鐃獣以駕申鐃緒申鐃緒申鐃駿誌申鐃所が鐃緒申能鐃叔わ申鐃緒申 鐃緒申鐃緒申9.9.4 鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 鐃緒申鐃緒申鐃緒申SQL鐃舜随申鐃叔わ申鐃所、鐃叔￥申鐃緒申鐃緒申鐃緒申文鐃緒申鐃緒申箸鐃緒申鐃叔э申鐃�鐃緒申鐃緒申覆鐃�鐃緒申鐃夙わ申鐃緒申鐃春わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申
鐃緒申鐃緒申/鐃緒申鐃緒型鐃塾緒申鐃熟書式は￥申ISO 8601鐃緒申SQL鐃緒申Ingres鐃祝￥申鐃緒申鐃緒申的鐃緒申POSTGRES鐃緒申Unix date鐃書式）まわ申鐃緒申German鐃塾ｏ申鐃縦のわ申鐃緒申鐃曙か鐃緒申鐃緒申鐃所さ鐃緒申泙鐃緒申鐃� 鐃叔フワ申鐃緒申箸鐃�ISO鐃書式でわ申鐃緒申 鐃緒申標鐃緒申SQL鐃叔わ申ISO 8601鐃書式の誌申鐃術わ申鐃緒申鐃緒申鐃銃わ申鐃殉わ申鐃緒申 "SQL"鐃夙わ申鐃緒申鐃緒申鐃熟緒申名鐃緒申鐃緒申鐃重�鐃淑誌申鐃塾でわ申鐃緒申鐃緒申 表8-14鐃祝各緒申鐃熟書式わ申鐃緒申鮗┐鐃緒申泙鐃緒申鐃� date鐃緒申time鐃塾書式は￥申鐃緒申鐃緒申鐃殉でわ申覆鐃緒申鐃緒申鐃緒申譴随申鐃塾わ申鐃曙ぞ鐃緒申鐃緒申鐃春と誌申鐃緒申鐃緒申鐃淑�鐃夙なわ申泙鐃緒申鐃�
表 8-14. 鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申老鐃緒申鐃�
| 鐃粛種申鐃緒申鐃緒申 | 鐃緒申鐃緒申 | 鐃緒申 |
|---|---|---|
| ISO | ISO 8601/標鐃緒申SQL | 1997-12-17 07:37:16-08 |
| SQL | 鐃緒申鐃緒申的鐃緒申鐃粛種申 | 12/17/1997 07:37:16.00 PST |
| Postgres | 鐃緒申有鐃緒申鐃粛種申 | Wed Dec 17 07:37:16 1997 PST |
| German | 鐃熟逸申鐃緒申鐃緒申夕鐃� | 17.12.1997 07:37:16.00 PST |
鐃緒申鐃緒申: ISO 8601鐃塾誌申鐃粛でわ申鐃緒申文鐃緒申鐃緒申T鐃緒申鐃緒申鐃春と誌申鐃瞬わ申分鐃巡し鐃殉わ申鐃緒申 PostgreSQL鐃緒申鐃緒申鐃熟ではわ申鐃塾書式わ申鐃緒申鐃緒申佞鐃緒申泙鐃緒申鐃緒申鐃緒申綉�鐃塾よう鐃祝緒申鐃熟でわ申T鐃叔はなわ申鐃緒申鐃緒申鐃緒申鐃術わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申匹澆笋刻申鐃緒申鐃渋常申離如鐃緒申鐃緒申戞鐃緒申鐃緒申鐃緒申鐃緒申謄鐃緒申同鐃粛わ申RFC3339鐃祝緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申櫃弔鐃緒申鐃叔わ申鐃緒申
SQL鐃緒申POSTGRES鐃叔は￥申DMY鐃春ワ申鐃緒申鐃緒申表腓�鐃緒申鐃所さ鐃曙た鐃緒申鐃熟件申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃所が鐃淑わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申坊遒�鐃緒申鐃緒申泙鐃緒申鐃� 鐃淑わ申鐃緒申鐃緒申鐃所が鐃緒申鐃緒申鐃粛の駕申鐃祝どわ申鐃銃駈申鐃緒申与鐃緒申鐃緒申里鐃緒申砲弔鐃緒申討鐃�鐃緒申8.5.1鐃薯参考にわ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃祝￥申 表8-15鐃緒申鐃緒申鮗┐鐃緒申泙鐃緒申鐃�
表 8-15. 鐃緒申鐃春の緒申鐃緒申隆鐃緒申鐃�
| datestyle鐃緒申鐃緒申鐃緒申 | 鐃緒申鐃熟の緒申鐃� | 鐃緒申鐃緒申鐃緒申 |
|---|---|---|
| SQL, DMY | day鐃緒申鐃緒申鐃緒申/month鐃淑件申鐃�/year鐃緒申年鐃緒申 | 17/12/1997 15:37:16.00 CET |
| SQL, MDY | month鐃淑件申鐃�/day鐃緒申鐃緒申鐃緒申/year鐃緒申年鐃緒申 | 12/17/1997 07:37:16.00 PST |
| Postgres, DMY | day鐃緒申鐃緒申鐃緒申/month鐃淑件申鐃�/year鐃緒申年鐃緒申 | Wed 17 Dec 07:37:16 1997 PST |
鐃醇ー鐃緒申鐃緒申SET DATESTYLE鐃緒申鐃殉ワ申鼻鐃�postgresql.conf鐃緒申鐃緒申鐃春ワ申鐃緒申鐃緒申鐃�DateStyle鐃術ワ申瓠種申鐃緒申鐃緒申鐃緒申鐃緒申謄鐃緒申鐃緒申个鐃緒申鐃緒申薀わ申鐃緒申鐃夙わ申PGDATESTYLE鐃縦駈申鐃術随申鐃緒申鐃緒申僂鐃緒申董鐃緒申鐃緒申鐃�/鐃緒申鐃緒申鐃緒申夕鐃緒申鐃緒申鐃緒申鬚垢襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申呂里鐃緒申鐃緒申鐃淑緒申鐃緒申鐃緒申鐃緒申法鐃夙わ申鐃銃￥申鐃緒申鐃緒申鐃緒申愎鐃�to_char鐃緒申鐃緒申9.8鐃薯参照）わ申鐃緒申僂鐃緒申襪鰹申箸鐃叔わ申鐃殉わ申鐃緒申
鐃緒申鐃緒申鐃俊わ申鐃緒申啝鐃緒申鐃緒申咾亮鐃緒申鐃緒申鐃緒申狼鐃塾器申鐃緒申鐃緒申的鐃緒申鐃叔のみでなわ申鐃緒申鐃緒申的判鐃叔に影駈申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃祝まわ申鐃緒申鐃緒申鐃緒申鐃緒申咾鐃�1900年鐃緒申鐃宿醐申牴緒申鐃緒申譴随申茲�鐃叔わ申鐃緒申鐃緒申鐃獣に夏誌申鐃瞬居申則鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃緒申儿鐃緒申鐃緒申觀刻申鐃緒申鐃渋鰹申鐃緒申討鐃緒申泙鐃緒申鐃� PostgreSQL鐃緒申鐃緒申鐃重�鐃淑誌申鐃緒申鐃俊ルー鐃緒申砲弔鐃緒申討両鐃緒申鐃祝￥申鐃緒申鐃緒申鐃夙わ申鐃銃わ申鐃緒申zoneinfo鐃緒申鐃緒申鐃俊デ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申僂鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申了鐃緒申屬蓮鐃緒申鐃緒申鐃粛随申鐃緒申鐃曙た鐃緒申鐃緒申鐃俊わ申鐃出わ申鐃緒申膿鐃緒申隆鐃緒申里離襦種申襪�鐃緒申鐃緒申鐃緒申長鐃緒申鐃緒申鐃熟りそ鐃塾まま緒申蕕�鐃緒申続鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃夙わ申鐃緒申鐃緒申箸鐃緒申討鐃緒申泙鐃緒申鐃�
PostgreSQL鐃緒申鐃緒申鐃緒申的鐃祝誌申鐃術でわ申鐃緒申茲�鐃緒申標鐃緒申SQL鐃舜の互器申鐃緒申鐃緒申鐃出わ申鐃緒申鐃緒申造鐃緒申鐃緒申呂鬚靴討鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申標鐃緒申SQL鐃祝は￥申鐃緒申鐃春と誌申鐃緒申離如鐃緒申鐃緒申鐃緒申筏鐃叔緒申亡悗鐃緒申觝�鐃署が醐申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 2鐃縦わ申鐃緒申鐃初か鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申焚鐃緒申房鐃緒申鐃緒申泙鐃緒申鐃�
date鐃緒申鐃祝はわ申鐃緒申亡鐃熟�鐃緒申鐃緒申鐃緒申鐃緒申咾鐃緒申鐃銃まわ申鐃藷が￥申time鐃緒申鐃祝はわ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃渋わ申鐃緒申鐃緒申鐃祝わ申鐃緒申鐃銃￥申鐃緒申鐃緒申鐃俊のワ申鐃春ワ申鐃獣トわ申鐃銃誌申鐃瞬へわ申鐃准わ申鐃舜わ申鐃祝わ申鐃叔�鐃瞬わ申鐃縮わ申鐃緒申鐃術駕申鐃緒申鐃暑こ鐃夙わ申鐃初、鐃緒申鐃緒申鐃銃縁申佑鐃緒申鐃緒申佞發緒申鐃祝件申鐃緒申佞鐃緒申鐃緒申討鐃緒申覆鐃緒申醗鐃縮ｏ申鐃緒申鐃緒申鐃殉わ申鐃緒申
鐃叔フワ申鐃緒申箸了鐃緒申鐃緒申咾鐃�UTC鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃春ワ申鐃獣トとわ申鐃銃誌申鐃所さ鐃緒申討鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃獣わ申DST鐃淑夏誌申鐃瞬）へわ申鐃准わ申鐃舜わ申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃�/鐃緒申鐃緒申藥誌申鐃峻わ申鐃緒申隋�鐃銃誌申鐃瞬わ申適鐃術わ申鐃暑こ鐃夙わ申鐃峻駕申能鐃叔わ申鐃緒申
鐃緒申鐃塾よう鐃緒申鐃緒申鐃緒申鐃緒申茲刻申襪随申鐃祝は￥申鐃緒申鐃緒申鐃俊わ申鐃緒申僂鐃緒申鐃楯わ申鐃緒申鐃春と誌申鐃緒申鐃塾常申鐃緒申鐃緒申飮鐃緒申任鐃緒申鐃緒申鐃緒申鐃�/鐃緒申鐃緒申如鐃緒申鐃緒申鐃緒申鐃緒申鐃術わ申鐃暑こ鐃夙を勧わ申泙鐃緒申鐃� time with time zone鐃緒申鐃塾誌申鐃術はわ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃淑わ申辰箸鐃�PostgreSQL鐃叔は￥申鐃曙式鐃塾ワ申鐃竣リケ鐃緒申鐃緒申鐃緒申鐃巡、標鐃緒申SQL鐃夙の互器申鐃緒申鐃塾わ申鐃緒申法鐃�time with time zone鐃緒申鐃塾誌申鐃術をサポ￥申鐃夙わ申鐃銃わ申鐃殉わ申鐃祝￥申 PostgreSQL鐃熟￥申鐃緒申鐃春まわ申鐃熟誌申鐃緒申里澆鐃緒申飮鐃緒申鐃緒申鐃叔￥申鐃緒申鐃緒申鐃塾わ申鐃駿ては誌申鐃緒申鐃緒申了鐃緒申鐃緒申咾任鐃緒申鐃緒申鐃緒申鐃藷してわ申鐃殉わ申鐃緒申
鐃緒申鐃駿ての誌申鐃緒申鐃緒申鐃春わ申鐃緒申鐃緒申鐃春と誌申鐃緒申鐃�UTC鐃緒申鐃緒申鐃緒申的鐃緒申鐃緒申存鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃熟ワ申鐃初イ鐃緒申鐃緒申箸鐃宿緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申TimeZone鐃緒申鐃緒申僖鐃潤ー鐃緒申鐃叔誌申鐃所さ鐃曙た鐃緒申鐃緒申鐃俊にわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃瞬わ申鐃術器申鐃緒申鐃緒申泙鐃緒申鐃�
PostgreSQL鐃叔は￥申3鐃縦の件申鐃緒申鐃叔誌申鐃緒申鐃俊わ申鐃緒申蠅刻申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�
America/New_York鐃淑どの器申鐃緒申鐃淑誌申鐃緒申鐃緒申名鐃塾￥申 認鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃縮常申里鐃�pg_timezone_names鐃俊ュー鐃緒申鐃緒申鵑気鐃銃わ申鐃殉わ申鐃緒申鐃緒申45.69鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃祝￥申 PostgreSQL鐃熟わ申鐃緒申鐃緒申的鐃塾わ申鐃緒申砲茲�鐃緒申鐃術わ申鐃緒申討鐃緒申鐃�zoneinfo鐃緒申鐃緒申鐃俊デ￥申鐃緒申鐃緒申鐃緒申僂鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃獣て￥申多鐃緒申鐃緒申他鐃塾ワ申鐃春トワ申鐃緒申鐃緒申鐃叔わ申同鐃緒申名鐃緒申鐃緒申認鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
PST鐃淑どの誌申鐃緒申鐃俊常申略鐃緒申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃獣縁申鐃緒申鐃緒申鐃緒申UTC鐃緒申鐃緒申離鐃緒申侫鐃緒申奪箸鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑誌申鐃緒申鐃緒申名鐃塾では夏誌申鐃緒申鐃緒申鐃旬居申則鐃緒申鐃緒申鐃夙み刻申鐃殉わ申泙鐃緒申鐃� 認鐃緒申鐃緒申能鐃淑常申略鐃緒申鐃緒申pg_timezone_abbrevs鐃俊ュー鐃緒申鐃緒申鵑気鐃銃わ申鐃殉わ申鐃緒申鐃緒申45.68鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃祝￥申 鐃緒申鐃緒申鐃俊常申略鐃緒申鐃緒申鐃出わ申鐃緒申TimeZone鐃緒申鐃緒申僖鐃潤ー鐃緒申鐃緒申鐃緒申鐃�log_timezone鐃緒申鐃緒申僖鐃潤ー鐃緒申鐃緒申鐃緒申鐃所す鐃暑こ鐃夙はでわ申鐃殉わ申鐃藷が￥申鐃緒申鐃春誌申鐃緒型鐃緒申鐃緒申鐃緒申鐃粛わ申AT TIME ZONE鐃初算鐃述に常申略鐃緒申鐃緒申鐃緒申僂鐃緒申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申名鐃巡そ鐃塾常申略鐃緒申鐃祝加わ申鐃緒申PostgreSQL鐃熟￥申STDoffset鐃緒申STDoffsetDST鐃夙わ申鐃緒申鐃緒申鐃緒申鐃緒申POSIX鐃粛種申鐃塾誌申鐃緒申鐃俊誌申鐃緒申鐃緒申鐃春わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃叔￥申STD鐃熟誌申鐃緒申鐃俊常申略鐃緒申鐃緒申offset鐃緒申UTC鐃緒申鐃緒申鐃緒申鐃祝随申鐃緒申鐃緒申鐃緒申鐃緒申単鐃縮のワ申鐃春ワ申鐃獣トでわ申鐃緒申 鐃殉わ申鐃緒申DST鐃熟常申略鐃緒申能鐃叔夏誌申鐃瞬誌申鐃緒申鐃俊の常申略鐃緒申鐃叔￥申鐃緒申鐃所オ鐃春ワ申鐃獣トわ申鐃緒申1鐃緒申鐃瞬進むこ鐃夙わ申鐃縮ｏ申鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申EST5EDT鐃緒申認鐃緒申鐃術みの誌申鐃緒申鐃緒申名鐃叔なわ申鐃緒申鐃叔も、鐃緒申鐃春わ申鐃緒申譟�鐃順衆鐃緒申鐃曙海鐃淳誌申鐃瞬わ申同鐃緒申鐃緒申里箸鐃緒申鐃銃逸申遒件申泙鐃緒申鐃� 鐃銃誌申鐃瞬誌申鐃緒申鐃緒申名鐃緒申鐃緒申鐃緒申函鐃�zoneinfo鐃緒申鐃緒申鐃俊デ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申posixrules鐃緒申鐃旬で誌申鐃術わ申鐃緒申鐃銃誌申鐃緒申鐃術器申鐃緒申則鐃緒申同鐃緒申鐃緒申則鐃祝緒申鐃獣て誌申鐃術わ申鐃緒申鐃緒申里鐃緒申鐃緒申鵑気鐃殉わ申鐃緒申 標鐃緒申的鐃緒申PostgreSQL鐃緒申鐃藷ストレー鐃緒申鐃緒申鐃叔は￥申posixrules鐃緒申US/Eastern鐃緒申同鐃緒申鐃叔わ申鐃緒申 鐃緒申鐃塾わ申鐃緒申POSIX鐃書式の誌申鐃緒申鐃俊誌申鐃緒申鐃�USA鐃銃誌申鐃瞬居申則鐃祝緒申鐃緒申鐃殉わ申鐃緒申 必鐃竣に縁申鐃緒申鐃緒申posixrules鐃春ワ申鐃緒申鐃緒申鐃緒申屬鐃緒申鐃緒申鐃緒申襪鰹申箸如鐃緒申鐃緒申鐃銃逸申鐃緒申調鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申
鐃緒申鐃緒申埜鐃緒申鐃緒申函鐃緒申鐃緒申鐃熟常申略鐃緒申鐃緒申鐃緒申鐃緒申名鐃塾間の削申鐃循でわ申鐃緒申 鐃緒申略鐃緒申鐃緒申UTC鐃緒申鐃緒申鐃緒申蠅件申鐃緒申鐃緒申侫鐃緒申奪箸鐃宿緒申錣刻申里鐃緒申个鐃緒申董鐃緒申曚箸鐃宿の常申略鐃淑わ申鐃緒申名鐃塾はワ申鐃緒申鐃緒申鐃緒申硫道鐃緒申峙鐃緒申鐃緒申鐃縮ｏ申鐃緒申鐃塾で￥申UTC鐃緒申鐃春ワ申鐃獣トにはｏ申鐃縦の駕申能鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃俊常申略鐃熟わ申鐃緒申鐃緒申鐃緒申鐃薯検削申鐃緒申鐃淑わ申鐃緒申鐃潤、POSIX鐃書式誌申鐃緒申鐃俊居申能鐃叔はわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟わ申拗鐃淑わ申鐃緒申鐃緒申鐃春わ申鐃銃わ申鐃殉わ申鐃緒申能鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃緒申鐃春わ申鐃駿わ申鐃叔わ申鐃緒申 鐃純え鐃出￥申鐃緒申鐃緒申鐃銃ワ申鐃銃逸申鐃熟わ申鐃緒申鐃緒申辰鐃�UTC鐃塾常申略鐃熟わ申鐃緒申僂鐃渋鰹申鐃緒申鐃緒申鐃緒申屬如鐃�SET TIMEZONE TO FOOBAR0鐃叔わ申動鐃庶し鐃殉わ申鐃緒申 他鐃祝も、POSIX鐃緒申鐃緒申鐃緒申名鐃塾でわ申鐃緒申鐃塾ワ申鐃春ワ申鐃獣トわ申鐃緒申鐃緒申縫奪鐃緒申鐃�鐃緒申側鐃叔誌申鐃術わ申鐃緒申鐃夙わ申鐃緒申鐃緒申鐃緒申砲鐃緒申鐃緒申佞鐃緒申覆鐃緒申鐃出なわ申泙鐃緒申鐃� PostgreSQL鐃熟￥申他鐃叔はわ申鐃駿わ申ISO-8601鐃緒申鐃緒申砲鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申了鐃緒申鐃緒申咼鐃緒申侫鐃緒申奪箸魯鐃緒申鐃祝ッワ申鐃緒申鐃緒申鐃夙わ申鐃銃わ申鐃殉わ申鐃緒申
鐃緒申鐃駿ての常申鐃祝わ申鐃緒申鐃銃￥申鐃緒申鐃緒申鐃緒申名鐃緒申鐃緒申文鐃緒申鐃緒申文鐃緒申鐃塾駈申鐃縮なわ申認鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 鐃淑わ申鐃緒申鐃�PostgreSQL鐃塾バ￥申鐃緒申鐃緒申鐃�8.2鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申儿鐃緒申任鐃緒申鐃� 鐃緒申鐃緒申鐃熟わ申鐃駿てではわ申鐃緒申泙鐃緒申鵑�￥申鐃緒申鐃緒申文脈鐃叔わ申鐃緒申文鐃緒申鐃緒申文鐃緒申鐃緒申鐃緒申鐃縮わ申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃�
鐃緒申略鐃淑わ申鐃緒申鐃緒申略鐃緒申鐃塾どわ申鐃緒申皀居申鐃緒申鐃緒申鐃緒申鐃夙み刻申鐃殉わ申鐃緒け鐃叔はわ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃藷スト￥申鐃緒申妊鐃緒申譽�鐃夙ワ申鐃�.../share/timezone/鐃緒申鐃緒申鐃�.../share/timezonesets/鐃塾駕申鐃緒申鐃緒申存鐃緒申鐃緒申觜緒申鐃緒申侫鐃緒申鐃緒申襪�鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申B.3鐃薯参照わ申鐃緒申鐃緒申鐃緒申鐃祝￥申
TimeZone鐃緒申postgresql.conf鐃春ワ申鐃緒申鐃緒申鐃�鐃緒申18鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申他鐃緒申標鐃緒申的鐃緒申鐃緒申法鐃緒申鐃緒申鐃所す鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃淑駕申鐃祝￥申鐃緒申鐃緒申鐃縦わ申鐃緒申鐃縮わ申鐃緒申鐃緒申鐃緒申法鐃薯示わ申鐃殉わ申鐃緒申
SET TIME ZONE SQL鐃緒申鐃殉ワ申匹魯鐃緒申奪鐃緒申鐃緒申了鐃緒申鐃緒申咾鐃緒申鐃緒申蠅件申泙鐃緒申鐃� 鐃緒申鐃緒申鐃�SQL鐃緒申鐃粛互器申鐃緒申文法鐃祝わ申蟒常申辰討鐃緒申鐃�SET TIMEZONE TO鐃緒申鐃緒申名鐃叔わ申鐃緒申
PGTZ鐃縦駈申鐃術随申鐃熟￥申libpq鐃緒申鐃初イ鐃緒申鐃緒申箸鐃緒申鐃渋鰹申鐃緒申縫鐃緒申鐃緒申个鐃�SET TIME ZONE鐃緒申鐃殉ワ申匹鐃緒申鐃緒申鐃緒申鐃緒申襪随申鐃緒申鐃術わ申鐃緒申鐃殉わ申鐃緒申
interval鐃粛は以駕申鐃塾常申長鐃淑刻申文鐃緒申箸辰撞鐃緒申劼鐃緒申鐃殉わ申鐃緒申
[@] quantity unit [quantity unit...] [direction]
鐃緒申鐃緒申鐃叔￥申quantity鐃熟￥申鐃緒申鐃緒申佞鐃緒申忙鐃緒申鐃緒申漫鐃�unit鐃緒申単鐃縮）わ申microsecond鐃緒申millisecond鐃緒申second鐃緒申鐃獣）￥申minute鐃緒申分鐃祝￥申hour鐃淑誌申鐃祝￥申day鐃緒申鐃緒申鐃祝￥申week鐃淑緒申鐃祝￥申month鐃淑件申法鐃�year鐃緒申年鐃祝￥申decade鐃緒申10年単鐃縮）￥申century鐃緒申100年単鐃縮）￥申millennium鐃緒申1000年単鐃縮）わ申鐃暑い鐃熟わ申鐃緒申鐃緒申単鐃縮の器申略鐃緒申鐃殉わ申鐃緒申複鐃緒申鐃緒申鐃叔わ申鐃緒申 direction鐃緒申鐃緒申鐃緒申鐃祝わ申ago鐃盾し鐃緒申鐃熟駈申鐃叔わ申鐃緒申 鐃緒申鐃獣トマ￥申鐃緒申鐃緒申@鐃祝はワ申鐃竣ワ申鐃緒申鐃叔￥申鐃春わ申鐃銃わ申鐃春わ申鐃淑わ申鐃銃も構鐃緒申鐃殉わ申鐃緒申 鐃循なわ申単鐃縮にわ申鐃緒申鐃緒申鐃緒申鐃緒申未鐃重�鐃准わ申鐃緒申鐃緒申鐃塾醐申鐃緒申動鐃緒申鐃重�鐃緒申足鐃緒申鐃緒申泙鐃緒申鐃� ago鐃熟わ申鐃駿てのフワ申鐃緒申鐃緒申匹鐃夙薪常申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃塾刻申文鐃熟まわ申鐃緒申IntervalStyle鐃緒申postgres_verbose鐃緒申鐃緒申鐃所さ鐃緒申討鐃緒申鐃緒申鐃祝誌申鐃瞬間隔の緒申鐃熟でわ申鐃緒申僂鐃緒申鐃殉わ申鐃緒申
鐃緒申鐃緒申鐃緒申鐃緒申分鐃緒申鐃緒申鐃緒申鐃緒申辰了鐃緒申鐃緒申未鐃緒申鐃緒申鐃重�鐃緒申単鐃縮わ申鐃緒申蠅件申覆鐃緒申討盥緒申鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申'1 12:59:10'鐃緒申'1 day 12 hours 59 min 10 sec'鐃緒申1鐃緒申鐃緒申12鐃緒申鐃緒申59分10鐃獣）と駕申瓩居申鐃殉わ申鐃緒申 鐃殉わ申年鐃夙件申鐃緒申箸濆鐃緒せ鐃熟ワ申鐃獣ワ申鐃緒申鐃夙って誌申鐃所す鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃純え鐃出￥申'200-10'鐃緒申'200 years 10 months'鐃緒申200年鐃緒申10鐃緒申鐃緒申砲伐鐃潤さ鐃緒申泙鐃緒申鐃� 鐃淑実際わ申鐃緒申鐃塾器申略鐃緒申鐃緒申標鐃緒申SQL鐃叔居申鐃緒申鐃曙た鐃緒申里里澆任鐃緒申鐃� 鐃緒申鐃緒申鐃緒申IntervalStyle鐃緒申sql_standard鐃緒申鐃緒申鐃所さ鐃緒申討鐃緒申鐃緒申鐃祝緒申鐃熟でわ申鐃緒申僂鐃緒申鐃殉わ申鐃緒申鐃緒申
標鐃緒申鐃�4.4.3.2鐃緒申鐃�"鐃緒申鐃緒申文鐃緒申鐃春緒申"鐃殉わ申鐃緒申4.4.3.3鐃緒申鐃�"鐃緒申鐃舜緒申"鐃塾どわ申鐃初か鐃緒申鐃緒申僂鐃緒申董鐃緒申鐃緒申峇岾鐃緒申佑鐃�ISO 8601鐃緒申鐃瞬間隔とわ申鐃銃書くわ申鐃夙わ申任鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申文鐃緒申鐃春の書式は以駕申鐃塾よう鐃淑わ申里任鐃緒申鐃�
P quantity unit [ quantity unit ...] [ T [ quantity unit ...]]
文鐃緒申鐃緒申鐃�P鐃叔始まわ申覆鐃緒申鐃出ならず鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃祝わ申鐃緒申鐃緒申鐃緒申屬鐃盾た鐃初すT鐃緒申泙鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃緒申鐃術駕申能鐃緒申単鐃縮の常申略鐃緒申鐃緒申表8-16鐃祝種申鐃緒申鐃殉わ申鐃緒申 単鐃縮は常申略鐃緒申鐃銃も構鐃緒申鐃殉わ申鐃緒申 鐃殉わ申任鐃春の緒申鐃瞬で誌申鐃緒申任鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃緒申1鐃緒申鐃緒申蠑�鐃緒申鐃緒申単鐃縮わ申T鐃塾醐申暴颪�なわ申鐃緒申个覆鐃殉わ申鐃緒申 鐃獣わ申M鐃塾逸申味鐃緒申T鐃緒申鐃緒申鐃祝わ申鐃暑か鐃緒申砲鐃緒申襪�鐃祝逸申存鐃緒申鐃殉わ申鐃緒申
表 8-16. ISO 8601鐃祝わ申鐃緒申鐃緒申鐃緒申峇岾鐃獣縁申未両鐃塾�鐃緒申
| 鐃緒申略鐃緒申 | 鐃緒申味 |
|---|---|
| Y | 年 |
| M | 鐃緒申鐃緒申鐃緒申鐃緒申鐃淑�鐃祝わ申鐃緒申鐃緒申鐃� |
| W | 鐃緒申 |
| D | 鐃緒申 |
| H | 鐃緒申鐃緒申 |
| M | 分鐃淑誌申鐃緒申鐃緒申分鐃祝わ申鐃緒申鐃緒申鐃� |
| S | 鐃緒申 |
鐃縮の書式を示わ申鐃殉わ申鐃緒申
P [ years-months-days ] [ T hours:minutes:seconds ]
鐃緒申鐃緒申鐃緒申惱饉阿任蓮鐃淑醐申鐃緒申鐃緒申P鐃緒申鐃緒申呂泙鐃淑わ申鐃緒申个覆鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃銃￥申T鐃熟誌申鐃瞬間隔わ申鐃緒申鐃緒申鐃緒申分鐃夙誌申鐃緒申鐃緒申分鐃夙わ申分鐃巡し鐃殉わ申鐃緒申 鐃粛わ申ISO 8601鐃緒申鐃春わ申同鐃粛の随申鐃緒申鐃叔誌申鐃所さ鐃緒申泙鐃緒申鐃�
fields鐃緒申鐃緒申鐃夙って誌申鐃瞬間鰹申鐃緒申鐃緒申魑�述わ申鐃緒申鐃順、鐃殉わ申鐃熟￥申fields鐃緒申鐃粛わ申鐃緒申鐃緒申鐃緒申譴随申鐃緒申峇岾鐃緒申鐃緒申文鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申隋�鐃殉￥申鐃緒申鐃緒申鐃緒申討鐃緒申覆鐃緒申鐃緒申鐃緒申未硫鐃緒申鐃�fields鐃祝逸申存鐃緒申鐃殉わ申鐃緒申 鐃純え鐃緒申INTERVAL '1' YEAR鐃緒申1年鐃夙駕申瓩居申譟�鐃緒申鐃緒申鐃緒申INTERVAL '1'鐃緒申1鐃獣と駕申瓩居申鐃殉わ申鐃緒申 同鐃緒申鐃祝￥申fields鐃緒申鐃粛にわ申辰撞鐃緒申弔鐃緒申鐃緒申撚鐃緒申魅侫鐃緒申鐃緒申鐃宿わ申"鐃緒申側鐃緒申"鐃春ワ申鐃緒申鐃緒申鐃緒申佑老拗鐃淑わ申鐃緒申鐃祝器申鐃緒申鐃緒申泙鐃緒申鐃� 鐃純え鐃出￥申INTERVAL '1 day 2:03:04' HOUR TO MINUTE鐃夙書くわ申鐃夙で￥申鐃緒申鐃緒申鐃旬のフワ申鐃緒申鐃緒申匹郎鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申侫侫鐃緒申鐃緒申鐃宿は削申鐃緒申鐃緒申鐃殉わ申鐃緒申
標鐃緒申SQL鐃祝緒申鐃緒申鐃夙￥申鐃緒申鐃瞬間鰹申鐃粛のフワ申鐃緒申鐃緒申匹呂鐃緒申戮鐃銃縁申鐃緒申鐃緒申鐃緒申鐃緒申鐃淑わ申鐃緒申个覆鐃殉わ申鐃緒申 鐃緒申鐃塾わ申鐃潤、鐃緒申頭鐃緒申鐃緒申鐃緒申鐃緒申呂鐃緒申戮討離侫鐃緒申鐃緒申鐃宿わ申適鐃術わ申鐃緒申泙鐃緒申鐃� 鐃純え鐃出誌申鐃瞬間隔ワ申謄鐃緒申'-1 2:03:04'鐃緒申鐃緒申鐃緒申鐃緒申蓮鐃緒申鐃緒申鐃緒申鐃淑�鐃祝わ申鐃緒申鐃淑�鐃緒申鐃緒申鐃緒申分鐃祝わ申適鐃術わ申鐃緒申泙鐃緒申鐃� PostgreSQL鐃叔はフワ申鐃緒申鐃緒申匹飽曚覆鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃殉わ申鐃緒申鐃緒申的鐃祝テワ申鐃緒申鐃夙件申鐃緒申表鐃緒申鐃祝わ申鐃緒申鐃緒申謄侫鐃緒申鐃緒申鐃宿わ申鐃緒申立鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申弔鐃塾とわ申鐃銃逸申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃塾わ申鐃潤、鐃緒申鐃緒申鐃緒申任六鐃緒申鐃淑�鐃緒申鐃緒申鐃緒申分鐃緒申鐃緒申鐃叔わ申鐃緒申箸澆覆鐃緒申鐃殉わ申鐃緒申 IntervalStyle鐃緒申sql_standard鐃緒申鐃緒申鐃所さ鐃緒申討鐃緒申鐃緒申隋�鐃緒申頭鐃緒申鐃緒申鐃熟わ申鐃駿てのフワ申鐃緒申鐃緒申匹鐃重�鐃術わ申鐃緒申鐃緒申里箸澆覆鐃緒申鐃殉わ申鐃淑わ申鐃緒申鐃緒申他鐃緒申鐃緒申罎�鐃淑わ申鐃緒申鐃塾みでわ申鐃祝￥申 鐃緒申鐃緒申覆鐃緒申弌鐃緒申鐃緒申鐃重�鐃緒申PostgreSQL鐃塾駕申瓩�鐃緒申鐃術わ申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃宿わ申鐃緒申鐃緒申法鐃緒申鐃塾フワ申鐃緒申鐃緒申匹鐃緒申鐃緒申鐃緒申鐃祝は醐申鐃縮わ申鐃緒申鐃緒申的鐃緒申鐃緒申鐃緒申鐃春わ申鐃暑こ鐃夙を勧わ申泙鐃緒申鐃�
鐃緒申鐃緒申的鐃祝は￥申interval鐃緒申鐃粛は件申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃獣随申鐃夙わ申鐃銃鰹申納鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟件申砲鐃獣わ申鐃術わ申鐃殉わ申鐃緒申鐃緒申鐃銃誌申鐃瞬わ申導鐃緒申鐃緒申鐃緒申討鐃緒申鐃緒申1鐃緒申鐃緒申23鐃緒申鐃瞬でわ申鐃獣わ申鐃緒申25鐃緒申鐃瞬でわ申鐃獣わ申鐃所す鐃暑か鐃緒申任鐃緒申鐃�
鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申侫鐃緒申鐃緒申鐃宿わ申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃獣随申鐃春ワ申鐃緒申鐃緒申匹肋鐃緒申鐃緒申鐃緒申欖匹鐃緒申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申鐃瞬間隔わ申鐃縮常申鐃緒申鐃緒申鵝△發件申鐃緒申鐃�timestamp鐃緒申鐃緒申琉鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃塾で￥申鐃緒申鐃塾よう鐃緒申鐃緒申存鐃緒申鐃緒申个曚箸鐃宿の常申腓�鐃殉わ申鐃峻わ申鐃殉わ申鐃緒申
justify_days鐃緒申justify_hours鐃舜随申鐃緒申鐃縮常申鐃緒申楼呂鐃循わ申鐃緒申鐃緒申鐃祝わ申鐃夙誌申鐃緒申鐃縦器申鐃緒申任鐃緒申泙鐃緒申鐃�
鐃緒申長鐃緒申鐃緒申鐃熟書式￥申鐃緒申鐃緒申咫鐃緒申鐃緒申鐃塾�鐃淑書式の逸申鐃緒申鐃塾フワ申鐃緒申鐃緒申匹任蓮鐃緒申侫鐃緒申鐃緒申鐃緒申鐃粛は常申鐃緒申鐃緒申分鐃緒申鐃緒申弔鐃緒申箸鐃緒申任鐃緒申泙鐃緒申鐃� 鐃純え鐃緒申'1.5 week'鐃緒申'01:02:03.45'鐃叔わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃熟は鰹申納鐃塾削申適鐃准な件申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申耽鐃緒申鐃緒申儡鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃曙が鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申砲覆鐃緒申未箸覆鐃緒申隋�鐃緒申鐃緒申鐃緒申分鐃緒申1鐃緒申鐃�30鐃緒申鐃緒申1鐃緒申鐃緒申24鐃緒申鐃瞬とわ申鐃緒申鐃術器申鐃緒申則鐃緒申鐃緒申僂鐃緒申董鐃緒申鐃緒申鐃純い鐃緒申離侫鐃緒申鐃緒申鐃宿に加わ申鐃緒申鐃殉わ申鐃緒申 鐃純え鐃緒申'1.5 month'鐃緒申1鐃緒申鐃�15鐃緒申鐃夙なわ申泙鐃緒申鐃� 鐃獣わ申鐃緒申鐃緒申鐃緒申鐃熟にわ申鐃緒申鐃銃常申鐃緒申鐃薯示わ申鐃緒申鐃夙になわ申泙鐃緒申鐃�
表8-17鐃緒申有鐃緒申鐃緒申interval鐃緒申鐃熟のわ申鐃緒申鐃縦わ申鐃緒申鐃緒申鮗┐鐃緒申討鐃緒申泙鐃緒申鐃�
表 8-17. 鐃緒申鐃瞬間鰹申鐃緒申鐃緒申
| 鐃緒申 | 鐃緒申鐃緒申 |
|---|---|
| 1-2 | 標鐃緒申SQL鐃書式￥申1年2鐃緒申鐃緒申 |
| 3 4:05:06 | 標鐃緒申SQL鐃書式￥申3鐃緒申4鐃緒申鐃緒申5分6鐃緒申 |
| 1 year 2 months 3 days 4 hours 5 minutes 6 seconds | 鐃緒申鐃緒申的Postgres鐃書式￥申1年2鐃緒申3鐃緒申4鐃緒申鐃緒申5分6鐃緒申 |
| P1Y2M3DT4H5M6S | ISO 8601 "鐃緒申鐃緒申文鐃緒申鐃春わ申鐃緒申"鐃緒申鐃緒申味鐃熟常申鐃銃縁申鐃� |
| P0001-02-03T04:05:06 | ISO 8601 "鐃緒申鐃舜緒申"鐃緒申鐃緒申味鐃熟常申鐃銃縁申鐃� |
鐃緒申鐃瞬間隔件申鐃塾緒申鐃熟書式は￥申SET intervalstyle鐃緒申鐃殉ワ申匹鐃緒申鐃術わ申鐃銃￥申sql_standard鐃緒申postgres鐃緒申postgres_verbose鐃殉わ申鐃緒申iso_8601鐃塾ｏ申鐃縦のわ申鐃緒申鐃塾ｏ申鐃縦わ申鐃緒申鐃緒申任鐃緒申泙鐃緒申鐃� 鐃叔フワ申鐃緒申箸鐃�postgres鐃書式でわ申鐃緒申 表8-18鐃熟わ申鐃曙ぞ鐃緒申僚鐃緒申老鐃緒申鐃緒申鮗┐鐃緒申鐃緒申鐃叔わ申鐃緒申
sql_standard鐃緒申鐃緒申鐃熟￥申鐃緒申鐃瞬間鰹申鐃粛わ申標鐃緒申鐃緒申鐃緒申聞鐃緒申鐃緒申鐃緒申任鐃緒申鐃緒申蕕�鐃緒申鐃淳わ申鐃銃わ申鐃淑わ申年鐃緒申鐃夙件申鐃緒申里漾鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申隼鐃緒申屬里漾砲鐃緒申鐃渋�鐃緒申鐃緒申鐃順、鐃緒申鐃瞬間隔ワ申謄鐃緒申文鐃緒申鐃緒申鐃緒申个鐃宿醐申鐃�SQL鐃祝緒申鬚垢鐃緒申鐃熟わ申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃叔なわ申鐃緒申弌鐃緒申鐃緒申呂蓮鐃緒申鐃緒申藝�鐃淳わ申鐃緒申鐃緒申鐃瞬間隔のわ申鐃緒申鐃殉わ申鐃緒申鐃緒申無鐃緒申鐃緒申鐃緒申鐃緒申的鐃緒申鐃緒申罎�鐃春加わ申鐃曙、鐃緒申鐃緒申-鐃緒申鐃瞬随申鐃緒申謄鐃緒申文鐃緒申鐃緒申鐃夙種申辰鐃宿醐申鐃叔�鐃緒申-鐃緒申鐃緒申鐃銃ワ申鐃淑醐申鐃緒申鐃塾よう鐃祝なわ申泙鐃緒申鐃�
postgres鐃書式の緒申鐃熟は￥申DateStyle鐃術ワ申瓠種申鐃緒申鐃�ISO鐃緒申鐃緒申鐃所さ鐃曙た鐃夙わ申鐃緒申8.4鐃緒申鐃緒申鐃塾ワ申蝓種申鐃緒申醗鐃緒申廚鐃緒申泙鐃緒申鐃�
postgres_verbose鐃書式の緒申鐃熟は￥申DateStyle鐃術ワ申瓠種申鐃緒申鐃�ISO鐃緒申鐃緒申鐃所さ鐃曙た鐃夙わ申鐃緒申8.4鐃緒申鐃緒申鐃塾ワ申蝓種申鐃緒申醗鐃緒申廚鐃緒申泙鐃緒申鐃�
iso_8601鐃書式の緒申鐃熟わ申ISO 8601 標鐃緒申鐃�4.4.3.2鐃緒申鐃緒申鐃緒申鐃緒申鐃祝居申鐃述わ申"format with designators鐃淑誌申名鐃春わ申鐃書式￥申"鐃祝逸申鐃竣わ申鐃殉わ申鐃緒申
表 8-18. 鐃緒申鐃瞬間隔緒申鐃熟件申鐃緒申鐃緒申鐃緒申
| 鐃緒申鐃緒申鐃緒申鐃緒申 | 年-鐃緒申鐃緒申峇岾鐃� | 鐃緒申-鐃緒申鐃緒申鐃緒申峇岾鐃� | 鐃緒申鐃淳わ申鐃緒申鐃緒申鐃瞬間鰹申 |
|---|---|---|---|
| sql_standard | 1-2 | 3 4:05:06 | -1-2 +3 -4:05:06 |
| postgres | 1 year 2 mons | 3 days 04:05:06 | -1 year -2 mons +3 days -04:05:06 |
| postgres_verbose | @ 1 year 2 mons | @ 3 days 4 hours 5 mins 6 secs | @ 1 year 2 mons -3 days 4 hours 5 mins 6 secs ago |
| iso_8601 | P1Y2M | P3DT4H5M6S | P-1Y-2M3DT-4H-5M-6S |
| 鐃緒申鐃塾ペ￥申鐃緒申 | 鐃循￥申鐃緒申 | 鐃緒申鐃塾ペ￥申鐃緒申 |
| 鐃出ワ申鐃淑ワ申鐃緒申如鐃緒申鐃緒申鐃� | 鐃緒申鐃緒申鐃緒申 | 鐃緒申鐃緒申鐃粛デ￥申鐃緒申鐃緒申 |