他鐃塾バ￥申鐃緒申鐃緒申鐃緒申文鐃緒申 鐃緒申 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9.6 | 9.5 | 9.4 | 9.3 | 9.2 | 9.1 | 9.0 | 8.4 | 8.3 | 8.2 | 8.1 | 8.0 | 7.4 | 7.3 | 7.2
PostgreSQL 9.2.4文鐃緒申
鐃緒申鐃塾ペ￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申 9鐃熟関随申鐃夙演算鐃緒申鐃緒申鐃塾ペ￥申鐃緒申

9.9. 鐃緒申鐃緒申/鐃緒申鐃緒申愎鐃緒申髪藥誌申鐃�

表9-27鐃熟￥申鐃緒申鐃緒申/鐃緒申鐃緒型鐃緒申鐃粛の緒申鐃緒申鐃叔誌申鐃術駕申能鐃淑関随申鐃薯示わ申鐃銃わ申鐃殉わ申鐃緒申鐃旬細は￥申鐃淑駕申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�表9-26鐃熟￥申鐃緒申+鐃緒申*鐃緒申鐃塾）器申鐃緒申的鐃淑誌申鐃術演算鐃述の随申鐃書いわ申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申愎鐃緒申砲弔鐃緒申討鐃�鐃緒申9.8鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申8.5鐃薯参照わ申鐃銃￥申鐃緒申鐃緒申/鐃緒申鐃緒申如鐃緒申鐃緒申鐃緒申砲弔鐃緒申討鐃緒申愀覆箸覆辰討鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申未鐃緒申討鐃緒申覆鐃緒申鐃出なわ申泙鐃緒申鐃�

鐃緒申劼鐃�time鐃盾し鐃緒申鐃緒申timestamp鐃緒申鐃緒申鐃緒申鐃熟わ申鐃緒申鐃緒申鐃緒申愎鐃緒申鐃緒申鐃俊演算鐃述わ申鐃緒申鐃銃￥申鐃渋際にわ申2鐃縦の種申鐃準が鐃緒申鐃緒申泙鐃緒申鐃�1鐃縦わ申time with time zone鐃緒申鐃殉わ申鐃緒申timestamp with time zone鐃緒申鐃緒申鐃緒申鐃塾で￥申鐃盾う1鐃縦わ申time without time zone鐃緒申鐃盾し鐃緒申鐃緒申timestamp without time zone鐃緒申鐃緒申鐃緒申鐃塾でわ申鐃緒申鐃緒申略鐃塾わ申鐃潤、鐃緒申鐃緒申鐃塾種申鐃緒申琉磴わ申聾鐃緒申未房鐃緒申鐃緒申討鐃緒申泙鐃緒申鵝�まわ申鐃緒申+鐃緒申*鐃初算鐃述は醐申鐃緒申藥誌申劼鐃緒申鐃緒申鐃殉わ申鐃緒申鐃純え鐃緒申date + integer鐃緒申integer + date鐃祝￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃夙み刻申錣誌申鐃緒申鐃緒申鐃緒申里濕鐃緒申鐃緒申泙鐃緒申鐃�

表 9-26. 鐃緒申鐃緒申/鐃緒申鐃緒申藥誌申鐃�

鐃初算鐃緒申名鐃緒申鐃緒申鐃�
+ date '2001-09-28' + integer '7'date '2001-10-05'
+ date '2001-09-28' + interval '1 hour'timestamp '2001-09-28 01:00:00'
+ date '2001-09-28' + time '03:00'timestamp '2001-09-28 03:00:00'
+ interval '1 day' + interval '1 hour'interval '1 day 01:00:00'
+ timestamp '2001-09-28 01:00' + interval '23 hours'timestamp '2001-09-29 00:00:00'
+ time '01:00' + interval '3 hours'time '04:00:00'
- - interval '23 hours'interval '-23:00:00'
- date '2001-10-01' - date '2001-09-28'integer '3'鐃緒申鐃緒申鐃春￥申
- date '2001-10-01' - integer '7'date '2001-09-24'
- date '2001-09-28' - interval '1 hour'timestamp '2001-09-27 23:00:00'
- time '05:00' - time '03:00'interval '02:00:00'
- time '05:00' - interval '2 hours'time '03:00:00'
- timestamp '2001-09-28 23:00' - interval '23 hours'timestamp '2001-09-28 00:00:00'
- interval '1 day' - interval '1 hour'interval '1 day -01:00:00'
- timestamp '2001-09-29 03:00' - timestamp '2001-09-27 12:00'interval '1 day 15:00:00'
* 900 * interval '1 second'interval '00:15:00'
* 21 * interval '1 day'interval '21 days'
* double precision '3.5' * interval '1 hour'interval '03:30:00'
/ interval '1 hour' / double precision '1.5'interval '00:40:00'

表 9-27. 鐃緒申鐃緒申/鐃緒申鐃緒申愎鐃�

鐃舜随申名鐃緒申鐃緒申遊鐃�鐃緒申鐃緒申鐃緒申鐃緒申鐃�
age(timestamp, timestamp) interval鐃緒申鐃緒申鐃瞬の醐申鐃緒申鐃緒申年鐃夙件申鐃緒申鐃術わ申鐃緒申"鐃緒申鐃緒申椒鐃祝わ申鐃�"鐃緒申未鐃緒申鐃緒申鐃�age(timestamp '2001-04-10', timestamp '1957-06-13')43 years 9 mons 27 days
age(timestamp)intervalcurrent_date鐃淑醐申鐃緒申鐃緒申鐃緒申鐃祝わ申鐃初減鐃緒申age(timestamp '1957-06-13')43 years 8 mons 3 days
clock_timestamp() timestamp with time zone鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申任鐃緒申鐃緒申鐃淑醐申孫垰鐃緒申鐃緒申僂鐃緒申泙鐃緒申鐃緒申鐃�鐃緒申9.9.4鐃薯参照￥申   
current_date date鐃緒申鐃淳わ申鐃緒申鐃春￥申鐃緒申9.9.4鐃薯参常申   
current_time time with time zone鐃緒申鐃淳の誌申鐃緒。鐃緒申9.9.4鐃薯参照￥申   
current_timestamp timestamp with time zone鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申文鐃緒申澆離肇鐃藷ザワ申鐃緒申鐃緒申鐃塾鰹申鐃緒申鐃緒申鐃春誌申鐃緒申法鐃�鐃緒申9.9.4鐃薯参照￥申   
date_part(text, timestamp) double precision鐃緒申分鐃春ワ申鐃緒申鐃緒申匹亮鐃緒申鐃緒申鐃�extract鐃緒申同鐃緒申鐃祝￥申鐃緒申9.9.1鐃薯参照￥申 date_part('hour', timestamp '2001-02-16 20:38:40')20
date_part(text, interval)double precision鐃緒申分鐃春ワ申鐃緒申鐃緒申匹亮鐃緒申鐃緒申鐃�extract鐃緒申同鐃緒申鐃祝￥申鐃緒申9.9.1鐃薯参照￥申 date_part('month', interval '2 years 3 months')3
date_trunc(text, timestamp) timestamp鐃緒申鐃所さ鐃曙た鐃緒申鐃駿わ申鐃准わ申里董鐃�鐃緒申9.9.2鐃盾参鐃夙￥申 date_trunc('hour', timestamp '2001-02-16 20:38:40')2001-02-16 20:00:00
extract(field from timestamp) double precision鐃緒申分鐃春ワ申鐃緒申鐃緒申匹亮鐃緒申鐃緒申鐃�鐃緒申9.9.1鐃薯参照￥申 extract(hour from timestamp '2001-02-16 20:38:40')20
extract(field from interval)double precision鐃緒申分鐃春ワ申鐃緒申鐃緒申匹亮鐃緒申鐃緒申鐃�鐃緒申9.9.1鐃薯参照￥申 extract(month from interval '2 years 3 months')3
isfinite(date) boolean鐃緒申鐃春わ申有鐃渋￥申+/-無鐃渋わ申鐃緒申鐃緒申鐃緒申鐃淑わ申鐃祝わ申鐃宿わ申鐃緒申鐃塾醐申鐃緒申isfinite(date '2001-02-16')true
isfinite(timestamp)boolean鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃粛�鐃渋￥申+/-無鐃渋でなわ申鐃祝わ申鐃宿わ申鐃緒申鐃塾醐申鐃緒申isfinite(timestamp '2001-02-16 21:28:30')true
isfinite(interval)boolean鐃緒申鐃瞬間隔わ申有鐃渋わ申鐃宿わ申鐃緒申鐃塾醐申鐃緒申isfinite(interval '4 hours')true
justify_days(interval) interval30鐃緒申鐃緒申鐃緒申鐃緒申1鐃緒申鐃宿緒申鐃緒申茲�鐃祝誌申鐃瞬間隔わ申調鐃緒申justify_days(interval '35 days')1 mon 5 days
justify_hours(interval) interval24鐃緒申鐃瞬わ申1鐃緒申鐃夙わ申鐃緒申鐃緒申峇岾屬鐃縦器申鐃�justify_hours(interval '27 hours')1 day 03:00:00
justify_interval(interval) intervaljustify_days鐃緒申鐃緒申鐃�justify_hours鐃緒申鐃緒申僂鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝わ申鐃縦器申鐃緒申鐃峻っての誌申鐃瞬間隔わ申調鐃緒申justify_interval(interval '1 mon -1 hour')29 days 23:00:00
localtime time鐃緒申鐃淳の誌申鐃緒。鐃緒申9.9.4鐃薯参照￥申   
localtimestamp timestamp鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申文鐃緒申澆離肇鐃藷ザワ申鐃緒申鐃緒申鐃塾鰹申鐃熟）￥申 鐃緒申9.9.4鐃薯参照￥申   
now() timestamp with time zone鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申文鐃緒申澆離肇鐃藷ザワ申鐃緒申鐃緒申鐃塾鰹申鐃熟）￥申 鐃緒申9.9.4鐃薯参照￥申   
statement_timestamp() timestamp with time zone鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申文鐃緒申澆鐃淑醐申粒鐃緒申蓮法鐃� 鐃緒申9.9.4鐃薯参照￥申   
timeofday() text鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒。鐃緒申clock_timestamp鐃夙誌申鐃銃わ申鐃殉わ申鐃緒申鐃緒申text鐃緒申文鐃緒申鐃緒申箸鐃緒申鐃緒申屬鐃緒申鐃緒申鐃�鐃緒申9.9.4鐃薯参照￥申   
transaction_timestamp() timestamp with time zone鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申文鐃緒申澆離肇鐃藷ザワ申鐃緒申鐃緒申鐃塾鰹申鐃熟）￥申 鐃緒申9.9.4鐃薯参照￥申   

鐃緒申鐃緒申鐃塾関随申鐃祝加わ申鐃緒申OVERLAPS SQL鐃初算鐃述わ申鐃緒申鐃楯￥申鐃夙わ申鐃緒申討鐃緒申泙鐃緒申鐃� 

(start1, end1) OVERLAPS (start2, end2)
(start1, length1) OVERLAPS (start2, length2)

鐃緒申鐃塾種申鐃熟￥申2鐃縦の誌申鐃瞬間隔わ申鐃重なわ申覆鐃緒申僚鐃獣種申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申忙鐃緒申某鐃緒申鐃緒申屬鐃緒申泙鐃緒申鐃緒申鼎覆鐃淑わ申鐃緒申鐃熟居申鐃緒申鐃瞬わ申鐃殉わ申鐃緒申鐃緒申端鐃緒申鐃緒申鐃春￥申鐃緒申鐃緒、鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廖鐃緒申發件申鐃緒申蓮鐃緒申鐃緒申鐃�/鐃緒申鐃緒申/鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃渋鰹申鐃緒申鐃緒申峇岾屬濃鐃緒申蠅居申鐃殉わ申鐃緒申鐃粛わ申鐃夙み刻申錣誌申鐃粛随申鐃緒申鐃曙た鐃楯￥申鐃緒申鐃熟と緒申了鐃塾わ申鐃緒申鐃緒申鐃緒申鐃祝居申鐃述わ申鐃銃も構鐃緒申鐃殉わ申鐃緒申OVERLAPS鐃緒申与鐃緒申鐃緒申譴随申佑鐃緒申癲�鐃純い鐃緒申里魍�始とわ申鐃銃逸申鐃緒申鐃殉わ申鐃緒申鐃銃誌申鐃瞬間隔は￥申start <=time < end鐃夙わ申鐃獣わ申半鐃緒申鐃緒申屬箸鐃緒申童鐃緒申覆鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申start鐃緒申end鐃緒申同鐃緒申鐃粛の常申鐃祝わ申単鐃緒申了鐃緒申鐃緒申鐃緒申箸覆鐃殉わ申鐃緒申鐃緒申鐃緒申蓮鐃緒申磴�鐃出緒申了鐃緒申鐃塾みわ申同鐃緒申鐃叔わ申鐃緒申2鐃縦の誌申鐃瞬間隔は￥申必鐃緒申鐃緒申鐃緒申鼎覆鐃淑わ申鐃緒申鐃夙わ申鐃縮ｏ申鐃緒申泙鐃緒申鐃� 

SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS
       (DATE '2001-10-30', DATE '2002-10-30');
Result: true
SELECT (DATE '2001-02-16', INTERVAL '100 days') OVERLAPS
       (DATE '2001-10-30', DATE '2002-10-30');
Result: false
SELECT (DATE '2001-10-29', DATE '2001-10-30') OVERLAPS
       (DATE '2001-10-30', DATE '2001-10-31');
Result: false
SELECT (DATE '2001-10-30', DATE '2001-10-30') OVERLAPS
       (DATE '2001-10-30', DATE '2001-10-31');
Result: true

timestamp with time zone鐃緒申鐃粛わ申interval鐃緒申鐃粛わ申辰鐃緒申鐃緒申鐃淑まわ申鐃緒申timestamp with time zone鐃緒申鐃粛わ申鐃緒申interval鐃緒申鐃粛を差わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃祝わ申鐃緒申鐃緒申分鐃熟￥申鐃緒申鐃祝わ申鐃塾随申鐃叔種申鐃緒申鐃曙た timestamp with time zone鐃緒申鐃緒申鐃春わ申鐃緒申某覆鐃殉わ申鐃淑もし鐃緒申鐃熟醐申鐃緒申瓩件申泙鐃緒申法鐃緒申道鐃緒申屬悗琉楾圓妨戮辰討鐃緒申儿鐃緒申亡悗鐃緒申討蓮淵鐃緒申奪鐃緒申鐃緒申了鐃緒申鐃緒申咾鐃�DST鐃緒申認鐃緒申鐃緒申鐃緒申茲�鐃祝なってわ申鐃緒申弌法鐃�interval '1 day'鐃緒申interval '24 hours'鐃緒申鐃緒申鐃緒申鐃緒申必鐃竣はわ申鐃緒申泙鐃緒申鐃緒申磴�鐃出￥申鐃緒申鐃獣ワ申鐃緒申鐃塾誌申鐃緒申鐃俊わ申 CST7CDT鐃緒申鐃緒申鐃所さ鐃緒申討鐃緒申鐃緒申鐃祝￥申 timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' 鐃熟￥申timestamp with time zone '2005-04-03 12:00-06'鐃緒申發随申蕕件申泙鐃緒申鐃緒申鐃緒申鐃銃縁申鐃緒申鐃緒申timestamp with time zone鐃緒申interval '24 hours'鐃緒申辰鐃緒申鐃夙￥申timestamp with time zone '2005-04-03 13:00-06'鐃夙わ申鐃緒申鐃緒申未砲覆鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申由鐃緒申CST7CDT鐃緒申鐃緒申鐃俊わ申2005-04-03 02:00鐃祝夏誌申鐃瞬へわ申鐃術刻申鐃緒申鐃緒申鐃暑か鐃緒申任鐃緒申鐃�

鐃循なわ申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃循なわ申泙鐃緒申里鐃�age鐃緒申鐃瞬わ申鐃緒申鐃�months鐃祝はわ申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�PostgreSQL鐃塾わ申鐃緒申鐃緒申老鐃祝まわ申鐃緒申鐃暑２鐃縦わ申鐃緒申鐃春の計誌申鐃祝わ申鐃緒申鐃銃￥申鐃緒申鐃春わ申鐃潤い鐃循わ申鐃塾件申鐃緒申鐃術わ申鐃殉わ申鐃緒申鐃純え鐃出￥申age('2004-06-01', '2004-04-30')鐃緒申4鐃緒申鐃緒申鐃術わ申鐃緒申1 mon 1 day鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃術わ申鐃緒申函鐃�5鐃緒申鐃�31鐃緒申鐃緒申鐃所、4鐃緒申鐃�30鐃緒申鐃塾わ申鐃潤、鐃緒申未鐃�1 mon 2 days鐃叔わ申鐃緒申

9.9.1. EXTRACT, date_part

EXTRACT(field FROM source)

extract鐃舜随申鐃熟￥申鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申佑鐃緒申鐃叔�鐃緒申鐃緒申覆匹鐃緒申鐃淑�鐃春ワ申鐃緒申鐃緒申匹鐃緒申鐃出わ申鐃殉わ申鐃緒申source鐃緒申timestamp鐃緒申鐃緒申time鐃緒申鐃緒申鐃殉わ申鐃緒申interval鐃緒申鐃緒申評鐃緒申鐃緒申鐃叔なわ申鐃緒申个覆鐃殉わ申鐃緒申鐃�date鐃緒申鐃塾種申鐃緒申timestamp鐃緒申鐃祝ワ申鐃純ス鐃夙わ申鐃緒申泙鐃緒申里如鐃銃縁申佑忙鐃緒申儔鐃叔緒申任鐃緒申法鐃�field鐃緒申source鐃緒申鐃粛わ申鐃緒申匹離侫鐃緒申鐃緒申鐃宿わ申鐃緒申个鐃緒申襪�鐃緒申鐃緒申鐃薯する識鐃縮子もし鐃緒申鐃緒申文鐃緒申鐃緒申任鐃緒申鐃�extract鐃舜随申鐃緒申double precision鐃緒申鐃緒申鐃粛わ申鐃瞬わ申鐃殉わ申鐃緒申鐃淑駕申鐃緒申有鐃緒申鐃淑フワ申鐃緒申鐃緒申鐃縮常申鮗┐鐃緒申泙鐃緒申鐃�

century

鐃緒申鐃緒申 

SELECT EXTRACT(CENTURY FROM TIMESTAMP '2000-12-16 12:21:13');
Result: 20
SELECT EXTRACT(CENTURY FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 21

鐃緒申鐃緒申鐃塾人￥申鐃祝はわ申鐃塾よう鐃淑意種申鐃熟わ申鐃緒申泙鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃叔緒申鐃緒申鐃緒申鐃緒申鐃�0001-01-01 00:00:00 AD鐃緒申鐃緒申呂泙鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申討離鐃緒申譽器申螢�鐃緒申鐃緒申鐃緒申鐃術わ申鐃緒申鐃緒申適鐃術わ申鐃緒申討鐃緒申泙鐃緒申鐃�0鐃夙わ申鐃緒申鐃粛わ申鐃緒申鐃緒申鐃熟わ申鐃緒申泙鐃緒申鐃�-1鐃緒申鐃緒申鐃塾種申鐃緒申1鐃緒申鐃緒申鐃叔わ申鐃緒申 鐃緒申鐃緒申鐃緒申鐃緒申鐃叔種申鐃緒申任鐃緒申覆鐃緒申鐃出￥申鐃緒申鐃緒申丱鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃術ワ申鐃緒申鐃緒申鐃緒申堂鐃塾ワ申鐃緒申鐃緒申法鐃緒申鐃緒申鐃緒申鐃緒申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申

PostgreSQL鐃緒申蝓種申鐃�8.0鐃緒申鐃緒申鐃叔は￥申鐃緒申鐃緒申鐃緒申鐃瞬刻申鐃春わ申鐃塾器申鐃緒申鐃祝緒申鐃獣てわ申鐃殉わ申鐃緒申任鐃緒申鐃緒申鐃獣縁申鐃叔�鐃緒申100鐃叔緒申鐃緒申鐃緒申鐃緒申鐃緒申里鐃緒申屬鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃�

day

timestamp鐃粛につわ申鐃銃は￥申(鐃緒申鐃緒申痢鐃緒申鐃緒申侫侫鐃緒申鐃緒申鐃宿￥申1鐃緒申31)鐃緒申interval鐃粛につわ申鐃銃わ申鐃緒申鐃春￥申 

SELECT EXTRACT(DAY FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 16

SELECT EXTRACT(DAY FROM INTERVAL '40 days 1 minute');
Result: 40
decade

年鐃春ワ申鐃緒申鐃緒申匹鐃�10鐃叔鰹申辰鐃緒申鐃緒申 

SELECT EXTRACT(DECADE FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 200
dow

鐃緒申鐃緒申鐃緒申鐃緒申0鐃祝わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申6鐃祝までわ申鐃緒申鐃緒申 

SELECT EXTRACT(DOW FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 5

extract鐃舜随申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃瞬刻申鐃�to_char(...,'D')鐃舜随申鐃塾わ申鐃緒申箸楼曚覆鐃緒申鐃緒申鐃緒申鐃緒申佞鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃�

doy

年鐃緒申任鐃緒申婿鐃緒申鐃緒申鐃緒申鐃�1鐃緒申365/366鐃緒申 

SELECT EXTRACT(DOY FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 47
epoch

timestamp with time zone鐃緒申鐃緒申鐃粛にわ申鐃緒申鐃銃￥申1970-01-01 00:00:00 UTC鐃緒申鐃緒申鐃緒申耽鐃緒申鐃緒申鐃塾随申鐃塾常申鐃盾あ鐃緒申法鐃�date鐃緒申timestamp鐃緒申鐃緒申鐃粛にわ申鐃緒申鐃銃￥申鐃緒申鐃緒申鐃緒申鐃暑タ鐃緒申鐃緒申鐃�1970-01-01 00:00:00鐃緒申鐃緒申鐃緒申耽鐃緒申鐃�interval鐃緒申鐃緒申鐃粛ではわ申鐃塾誌申鐃瞬間隔にわ申鐃緒申鐃緒申鐃獣の刻申廖鐃� 

SELECT EXTRACT(EPOCH FROM TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40.12-08');
Result: 982384720.12

SELECT EXTRACT(EPOCH FROM INTERVAL '5 days 3 hours');
Result: 442800

鐃淑駕申鐃祝￥申鐃緒申鐃塾経駕申鐃獣随申鐃薯タワ申鐃準ス鐃緒申鐃緒申鐃緒申佑鐃緒申儡鐃緒申鐃緒申鐃緒申鐃祝￥申鮗┐鐃緒申泙鐃緒申鐃� 

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 982384720.12 * INTERVAL '1 second';

(to_timestamp鐃舜随申鐃熟上記鐃緒申鐃術器申鐃薯カプワ申鐃暑化鐃緒申鐃殉わ申鐃緒申)

hour

鐃緒申鐃塾フワ申鐃緒申鐃緒申鼻鐃�0鐃緒申23鐃緒申 

SELECT EXTRACT(HOUR FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 20
isodow

鐃緒申鐃緒申鐃緒申鐃緒申1鐃祝わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申7鐃祝までわ申鐃緒申鐃緒申 

SELECT EXTRACT(ISODOW FROM TIMESTAMP '2001-02-18 20:38:40');
Result: 7

鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�dow鐃緒申同鐃曙。ISO 8601鐃緒申鐃緒申鐃瞬刻申鐃春わ申鐃祝逸申鐃竣￥申

isoyear

鐃緒申鐃春わ申同鐃緒申鐃緒申鐃緒申ISO 8601年鐃緒申interval鐃祝わ申鐃出縁申鐃緒申鐃淑わ申鐃祝￥申 

SELECT EXTRACT(ISOYEAR FROM DATE '2006-01-01');
Result: 2005
SELECT EXTRACT(ISOYEAR FROM DATE '2006-01-02');
Result: 2006

鐃緒申鐃銃わ申ISO年鐃熟ｏ申鐃庶４鐃緒申鐃緒申泙狃居申侶鐃緒申鐃緒申鐃緒申鐃緒申薐�鐃熟わ申鐃緒申泙鐃緒申鐃緒申鐃緒申辰董鐃緒申鐃緒申鐃緒申棔鐃緒申泙鐃緒申錬鐃緒申鐃緒申邁種申椶鐃�ISO年鐃緒申鐃緒申鐃曙ゴ鐃所オ年鐃夙異なわ申鐃叔緒申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申鐃緒申鐃旬細わ申week鐃春ワ申鐃緒申鐃緒申匹鮖仮箸鐃緒申討鐃緒申鐃緒申鐃緒申鐃緒申鐃�

鐃緒申鐃塾フワ申鐃緒申鐃緒申匹鐃�8.3鐃緒申鐃緒申鐃緒申PostgreSQL鐃緒申蝓種申鐃緒申任鐃粛�鐃緒申鐃叔わ申鐃緒申泙鐃緒申鐃�

microseconds

端鐃緒申鐃緒申分鐃緒申泙漾鐃�1,000,000鐃緒申茲醐申鐃曙た鐃獣フワ申鐃緒申鐃緒申鼻鐃緒申鐃緒申討鐃緒申辰鐃殉むこ鐃夙わ申鐃緒申鐃春￥申 

SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5');
Result: 28500000
millennium

鐃淳ワ申縫鐃緒申鐃緒申1鐃緒申年鐃緒申鐃瞬￥申 

SELECT EXTRACT(MILLENNIUM FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 3

1900年鐃緒申鐃叔�鐃緒申鐃緒申2鐃淳ワ申縫鐃緒申鐃叔わ申鐃緒申鐃緒申3鐃淳ワ申縫鐃緒申鐃緒申2001年1鐃緒申1鐃緒申鐃緒申鐃緒申呂泙鐃殉わ申鐃緒申鐃緒申

PostgreSQL鐃緒申蝓種申鐃�8.0鐃緒申鐃緒申鐃叔は￥申鐃淳ワ申縫鐃緒申鐃緒申鐃瞬刻申鐃春わ申鐃塾器申鐃緒申鐃祝緒申鐃獣てわ申鐃殉わ申鐃緒申任鐃緒申鐃緒申鐃獣縁申鐃叔�鐃春ワ申鐃緒申鐃緒申匹鐃�1000鐃叔鰹申辰鐃緒申佑鐃緒申屬鐃緒申討鐃緒申泙鐃緒申鐃緒申鐃�

milliseconds

端鐃緒申鐃緒申分鐃緒申泙漾鐃�1000鐃緒申茲醐申鐃曙た鐃獣フワ申鐃緒申鐃緒申鼻鐃緒申鐃緒申討鐃緒申辰鐃殉むこ鐃夙わ申鐃緒申鐃春わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申 

SELECT EXTRACT(MILLISECONDS FROM TIME '17:12:28.5');
Result: 28500
minute

分鐃春ワ申鐃緒申鐃緒申鼻鐃�0鐃緒申59鐃緒申 

SELECT EXTRACT(MINUTE FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 38
month

timestamp鐃緒申鐃緒申鐃粛わ申鐃出わ申鐃銃わ申年鐃緒申侶鐃緒申峭鐃緒申1鐃緒申12鐃祝￥申interval鐃緒申鐃緒申鐃粛わ申鐃出わ申鐃銃は件申鐃瞬刻申如鐃�12鐃塾常申余鐃緒申0鐃緒申11鐃祝￥申 

SELECT EXTRACT(MONTH FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 2

SELECT EXTRACT(MONTH FROM INTERVAL '2 years 3 months');
Result: 3

SELECT EXTRACT(MONTH FROM INTERVAL '2 years 13 months');
Result: 1
quarter

鐃緒申鐃緒申鐃緒申鐃春わ申鐃殉まわ申鐃叔�鐃塾誌申半鐃緒申鐃緒申1鐃緒申4鐃祝￥申 

SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 1
second

端鐃緒申鐃緒申泙鐃緒申鐃獣フワ申鐃緒申鐃緒申鼻鐃�0鐃緒申59鐃緒申[1]鐃祝￥申 

SELECT EXTRACT(SECOND FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 40

SELECT EXTRACT(SECOND FROM TIME '17:12:28.5');
Result: 28.5
timezone

鐃緒申単鐃縮わ申UTC鐃緒申鐃緒申了鐃緒申鐃緒申咼鐃緒申侫鐃緒申奪函鐃緒申鐃緒申鐃緒申佑鐃�UTC鐃緒申鐃緒申鐃塾誌申鐃緒申鐃俊わ申鐃出縁申鐃緒申鐃緒申鐃緒申鐃緒申佑鐃�UTC鐃緒申鐃緒申鐃緒申了鐃緒申鐃緒申咾鐃緒申弍鐃緒申鐃� (鐃緒申鐃緒申的鐃祝は￥申PostgreSQL鐃熟わ申鐃暑う鐃獣わ申鐃緒申鐃醇し鐃淑わ申鐃緒申鐃緒申UT1鐃緒申鐃緒申僉鐃�)

timezone_hour

鐃緒申鐃緒申鐃俊ワ申鐃春ワ申鐃獣トの誌申鐃緒申鐃緒申分鐃緒申

timezone_minute

鐃緒申鐃緒申鐃俊ワ申鐃春ワ申鐃獣トわ申分鐃緒申鐃緒申分鐃緒申

week

鐃緒申鐃緒申鐃緒申鐃緒申年鐃緒申鐃縮誌申鐃叔の緒申鐃緒申彁鐃緒申鐃緒申泙鐃緒申鐃緒申鐃�ISO 8601鐃塾￥申鐃緒申鐃緒申任禄鐃緒申老鐃緒申鐃緒申鐃緒申鐃緒申鐃熟まり、鐃緒申鐃緒申年鐃緒申1鐃緒申4鐃緒申鐃緒申泙狃居申鬚修鐃叔�鐃緒申鐃緒申1鐃緒申鐃夙わ申鐃銃わ申鐃殉わ申鐃緒申 鐃縦まり、年鐃塾最緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申觸居申鐃緒申鐃緒申鐃叔�鐃緒申鐃緒申1鐃緒申鐃夙なわ申泙鐃緒申鐃�

ISO鐃緒申鐃緒申鐃緒申任蓮鐃�1鐃緒申鐃緒申瓩わ申鐃緒申砲鐃緒申鐃緒申鐃叔�鐃緒申鐃緒申52鐃緒申鐃盾し鐃緒申鐃緒申鐃緒申53鐃緒申鐃夙なるこ鐃夙わ申鐃緒申鐃所、12鐃緒申鐃緒申戮鐃緒申鐃緒申砲鐃緒申砲麓鐃叔�鐃塾最緒申僚鐃緒申琉鐃緒申鐃緒申箸覆襪鰹申箸鐃緒申鐃緒申鐃殉わ申鐃緒申 鐃純え鐃出￥申2005-01-01鐃緒申2004年鐃緒申鐃緒申53鐃緒申鐃叔わ申鐃所、2006-01-01鐃緒申2005年鐃緒申鐃緒申52鐃緒申鐃塾逸申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申2012-12-31鐃緒申2013年鐃緒申鐃緒申1鐃緒申鐃塾逸申鐃緒申鐃夙なわ申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃塾わ申鐃緒申鐃縮わ申鐃緒申鐃暑た鐃潤、isoyear鐃春ワ申鐃緒申鐃緒申匹鐃�week鐃緒申併鐃術わ申鐃暑こ鐃夙わ申箴�鐃緒申鐃殉わ申鐃緒申 

SELECT EXTRACT(WEEK FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 7
year

年鐃春ワ申鐃緒申鐃緒申鼻鐃�AD鐃緒申年鐃緒申存鐃淳わ申鐃淑わ申鐃緒申鐃夙わ申忘鐃緒申覆鐃緒申任鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申里鐃緒申鐃�AD鐃緒申年鐃緒申鐃緒申BC鐃緒申年鐃薯減わ申鐃緒申鐃緒申砲鐃緒申鐃緒申佞鐃宿�鐃竣でわ申鐃緒申 

SELECT EXTRACT(YEAR FROM TIMESTAMP '2001-02-16 20:38:40');
Result: 2001

extract鐃舜随申鐃熟醐申鐃緒申鐃初算鐃緒申鐃緒申鐃緒申鐃緒申的鐃叔わ申鐃緒申鐃緒申鐃緒申鐃緒申/鐃緒申鐃緒申鐃緒申佑鐃宿緒申鐃緒申鐃緒申鐃緒申鐃重�鐃叔の書式につわ申鐃銃わ申鐃緒申9.8鐃薯参照わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申

date_part鐃舜随申鐃緒申鐃緒申鐃緒申的鐃緒申Ingres鐃緒申鐃緒申澤廚鐃緒申譴随申鐃塾で￥申標鐃緒申SQL鐃緒申extract鐃舜随申鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申 

date_part('field', source)

鐃緒申鐃緒申鐃緒申field鐃術ワ申瓠種申鐃緒申鐃縮常申鐃緒申任呂覆鐃淑醐申鐃緒申鐃緒申佑任鐃緒申鐃宿�鐃竣わ申鐃緒申鐃暑こ鐃夙わ申鐃緒申鐃春わ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申date_part鐃緒申有鐃緒申鐃淑フワ申鐃緒申鐃緒申鐃縮常申鐃�extract鐃緒申同鐃緒申鐃叔わ申鐃緒申 

SELECT date_part('day', TIMESTAMP '2001-02-16 20:38:40');
Result: 16

SELECT date_part('hour', INTERVAL '4 hours 3 minutes');
Result: 4

9.9.2. date_trunc

date_trunc鐃舜随申鐃熟鰹申念的鐃祝随申鐃粛わ申鐃出わ申鐃緒申trunc鐃舜随申鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃� 

date_trunc('field', source)

source鐃熟￥申鐃叔￥申鐃緒申鐃緒申timestamp鐃盾し鐃緒申鐃緒申interval鐃緒申評鐃緒申鐃緒申鐃叔わ申鐃淑デ￥申鐃緒申鐃緒申date鐃緒申time鐃熟わ申鐃曙ぞ鐃曙自動的鐃緒申timestamp鐃盾し鐃緒申鐃緒申interval鐃祝ワ申鐃純ス鐃夙わ申鐃緒申泙鐃緒申法鐃�field鐃熟￥申鐃緒申鐃緒申鐃粛わ申鐃粛わ申匹鐃緒申鐃緒申戮鐃緒申擇鐃塾てるか鐃緒申鐃緒申鐃薯しまわ申鐃緒申鐃緒申鐃緒申佑鐃緒申佑蓮鐃緒申鐃緒申鬚気譴随申鐃塾以駕申鐃薯ゼワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鳩鐃塾常申鐃緒申1鐃緒申鐃緒申鐃緒申砲鐃緒申鐃緒申鐃緒申鐃緒申討離侫鐃緒申鐃緒申鐃宿わ申鐃緒申鐃�timestamp鐃盾し鐃緒申鐃緒申interval鐃緒申鐃叔わ申鐃緒申

field鐃緒申有鐃緒申鐃粛には種申鐃塾わ申里鐃緒申鐃緒申鐃殉わ申鐃緒申

microseconds
milliseconds
second
minute
hour
day
week
month
quarter
year
decade
century
millennium

鐃純： 

SELECT date_trunc('hour', TIMESTAMP '2001-02-16 20:38:40');
Result: 2001-02-16 20:00:00

SELECT date_trunc('year', TIMESTAMP '2001-02-16 20:38:40');
Result: 2001-01-01 00:00:00

9.9.3. AT TIME ZONE

AT TIME ZONE鐃緒申文鐃緒申鐃緒申僂鐃緒申襪鰹申箸砲鐃所、鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃循なわ申鐃緒申鐃緒申咾鐃緒申儡鐃緒申鐃緒申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�表9-28鐃祝わ申鐃塾種申鐃緒申鮗┐鐃緒申泙鐃緒申鐃�

表 9-28. AT TIME ZONE Variants

鐃緒申鐃緒申鐃緒申鐃�鐃緒申鐃緒申
timestamp without time zone AT TIME ZONE zone timestamp with time zone与鐃緒申鐃緒申譴�鐃緒申鐃緒申鐃俊なわ申鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃所さ鐃曙た鐃緒申鐃緒申鐃俊にわ申鐃緒申箸鐃緒申銅鐃所扱鐃緒申鐃殉わ申鐃緒申
timestamp with time zone AT TIME ZONE zone timestamp without time zone与鐃緒申鐃緒申譴�鐃緒申鐃緒申鐃緒申鐃春わ申鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鮨卦鐃緒申了鐃緒申鐃緒申咾法鐃緒申鐃緒申鐃緒申咾了鐃緒申鐃淑わ申鐃術器申鐃緒申鐃殉わ申鐃緒申
time with time zone AT TIME ZONE zone time with time zone与鐃緒申鐃緒申譴随申鐃緒申鐃�with time zone鐃薯新わ申鐃緒申鐃緒申鐃緒申鐃俊わ申鐃術器申鐃緒申鐃殉わ申鐃緒申

鐃緒申鐃緒申鐃塾種申鐃叔は￥申鐃緒申鐃所す鐃緒申鐃緒申鐃緒申鐃�zone鐃熟￥申鐃緒申'PST'鐃塾よう鐃淑）テワ申鐃緒申鐃緒申文鐃緒申鐃藷、まわ申鐃熟￥申INTERVAL '-08:00'鐃塾よう鐃淑）誌申鐃瞬間隔で誌申鐃所す鐃暑こ鐃夙わ申鐃叔わ申鐃殉わ申鐃緒申 鐃銃ワ申鐃緒申鐃夙の常申隋�鐃緒申8.5.3鐃祝種申鐃緒申鐃緒申鐃緒申法鐃叔誌申鐃緒申鐃緒申名鐃塾わ申鐃緒申蠅刻申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃�

鐃淑駕申鐃緒申鐃緒申鮗┐鐃緒申泙鐃緒申淵鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃俊わ申PST8PDT鐃緒申鐃緒申鐃所し鐃銃わ申鐃殉わ申鐃祝￥申 

SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'MST';
Result: 2001-02-16 19:38:40-08

SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE 'MST';
Result: 2001-02-16 18:38:40

鐃叔緒申鐃緒申鐃熟￥申鐃緒申鐃緒申鐃俊のなわ申鐃緒申鐃緒申鐃竣ワ申鐃緒申鐃緒申廚鐃緒申鐃術わ申鐃緒申鐃緒申鐃緒申鐃�MST鐃緒申鐃瞬￥申UTC-7鐃祝とわ申鐃銃駕申瓩件申鐃�UTC鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃緒申鐃緒申譴�鐃初、UTC鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃宿緒申鐃緒申僂鐃�PST鐃緒申UTC-7鐃祝わ申鐃瞬わ申鐃緒申鐃緒申鐃緒申鐃殉わ申鐃緒申2鐃緒申鐃旬わ申鐃緒申蓮鐃�EST鐃緒申UTC-5鐃祝で誌申鐃所さ鐃曙た鐃緒申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃術わ申鐃緒申MST鐃緒申UTC-7鐃祝でのワ申鐃緒申鐃緒申鐃緒申鐃緒申屬鐃緒申儡鐃緒申鐃緒申討鐃緒申泙鐃緒申鐃�

鐃舜随申timezone(zone, timestamp)鐃熟￥申SQL鐃緒申鐃塾刻申文timestamp AT TIME ZONE zone鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申

9.9.4. Current Date/Time

PostgreSQL鐃熟￥申鐃緒申鐃淳わ申鐃緒申鐃春誌申鐃緒申亡悗鐃緒申鐃緒申佑鐃緒申屬鐃渋随申鐃緒申隆愎鐃緒申鐃緒申鷆，鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申標鐃緒申SQL鐃舜随申鐃熟わ申鐃駿て￥申鐃緒申鐃淳のトワ申鵐競鐃緒申鐃緒申鐃緒申粒鐃緒申六鐃緒申鐃祝器申鼎鐃緒申鐃緒申佑鐃緒申屬鐃緒申泙鐃緒申鐃� 

CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_TIME(precision)
CURRENT_TIMESTAMP(precision)
LOCALTIME
LOCALTIMESTAMP
LOCALTIME(precision)
LOCALTIMESTAMP(precision)

CURRENT_TIME鐃緒申鐃緒申鐃�CURRENT_TIMESTAMP鐃舜随申鐃叔は￥申鐃緒申鐃緒申鐃俊わ申伴鐃緒申鐃粛を扱わ申鐃殉わ申鐃緒申鐃緒申鐃緒申鐃緒申LOCALTIME鐃緒申鐃緒申鐃�LOCALTIMESTAMP鐃舜随申鐃叔は￥申鐃緒申鐃緒申鐃俊わ申伴鐃緒申覆鐃緒申佑魄靴鐃緒申泙鐃緒申鐃�

CURRENT_TIME鐃緒申CURRENT_TIMESTAMP鐃緒申LOCALTIME鐃緒申鐃緒申鐃緒申鐃�LOCALTIMESTAMP鐃舜随申鐃叔は￥申鐃緒申鐃駿のパワ申瓠種申鐃緒申鬟�プワ申鐃緒申鐃叔種申襪鰹申箸鐃緒申任鐃緒申鐃緒申鐃緒申鐃祝刻申錣誌申鐃緒申奪侫鐃緒申鐃緒申鐃宿わ申端鐃緒申鐃緒申鐃楯わ申鐃緒申未鐃盾た鐃初し鐃殉わ申鐃緒申鐃緒申鐃駿のパワ申瓠種申鐃緒申鐃緒申覆鐃緒申鐃順、鐃緒申未六鐃緒申儔鐃叔緒申丙鐃緒申鐃緒申鐃緒申戮能鐃緒申呂鐃緒申鐃殉わ申鐃緒申

鐃純： 

SELECT CURRENT_TIME;
Result: 14:39:53.662522-05

SELECT CURRENT_DATE;
Result: 2001-12-23

SELECT CURRENT_TIMESTAMP;
Result: 2001-12-23 14:39:53.662522-05

SELECT CURRENT_TIMESTAMP(2);
Result: 2001-12-23 14:39:53.66-05

SELECT LOCALTIMESTAMP;
Result: 2001-12-23 14:39:53.662522

鐃緒申鐃緒申鐃塾関随申鐃熟￥申鐃緒申鐃淳のトワ申鵐競鐃緒申鐃緒申鐃緒申粒鐃緒申六鐃緒申鐃緒申鐃瞬わ申鐃殉わ申鐃緒申 鐃緒申鐃緒申鐃粛は￥申鐃夙ワ申鵐競鐃緒申鐃緒申鐃藷が実行わ申鐃緒申討鐃緒申鐃瞬わ申鐃術駕申鐃緒申鐃殉わ申鐃緒申 鐃緒申鐃緒申蓮鐃緒申鐃緒申竜鐃叔緒申鐃銃わ申鐃緒申鐃緒申鐃縮でわ申鐃緒申 単鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申鐃叔￥申"current"鐃緒申鐃瞬わ申鐃緒申鐃緒申鐃緒申鐃緒申辰鐃宿緒申鐃緒申鐃峻わ申鐃緒申鐃夙わ申鐃叔わ申鐃緒申茲�鐃祝わ申鐃暑こ鐃夙わ申鐃緒申的鐃夙わ申鐃緒申鐃緒申鐃塾わ申鐃潤、同鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申鐃叔駕申鐃緒申鐃術刻申鐃緒申圓辰討鐃銃縁申鐃塾ワ申鐃緒申鐃準ス鐃緒申鐃緒申廚鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�

鐃緒申鐃緒申: 他鐃塾デ￥申鐃緒申鐃駿￥申鐃緒申鐃緒申鐃緒申鐃銃ワ申任蓮鐃緒申鐃緒申鐃緒申鐃緒申佑鐃緒申鐃緒申鐃緒申砲鐃緒申鐃緒申辰鐃緒申鐃緒申襪鰹申箸鐃緒申鐃緒申鐃殉わ申鐃緒申

PostgreSQL鐃熟まわ申鐃緒申鐃舜随申鐃緒申討喀个鐃緒申鐃緒申鐃緒申亮尊櫃慮鐃緒申濟鐃緒申鐃巡現鐃淳わ申文鐃塾鰹申鐃熟誌申鐃緒申鐃緒申屬鐃緒申愎鐃緒申鐃緒申鷆，鐃緒申泙鐃緒申鐃緒申鐃宿醐申鐃�SQL鐃塾関随申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申焚鐃緒申房鐃緒申鐃緒申泙鐃緒申鐃� 

transaction_timestamp()
statement_timestamp()
clock_timestamp()
timeofday()
now()

transaction_timestamp()鐃緒申CURRENT_TIMESTAMP鐃緒申鐃緒申鐃緒申鐃叔わ申鐃緒申鐃緒申鐃緒申鐃塾に駕申鐃緒申鐃瞬わ申鐃緒申鐃緒申反鐃叔わ申鐃緒申名鐃緒申鐃祝なってわ申鐃殉わ申鐃緒申 statement_timestamp()鐃熟醐申鐃淳わ申文鐃塾実行鰹申鐃熟誌申鐃緒申鐃緒申屬鐃緒申鐃塾でわ申鐃淑わ申鐃緒申鐃緒申的鐃祝わ申鐃緒申鐃夙￥申直鐃緒申鐃塾ワ申鐃殉ワ申疋鐃獣ワ申鐃緒申鐃緒申鐃薯クライ鐃緒申鐃緒申箸鐃緒申鐃緒申鐃緒申鐃緒申辰鐃緒申鐃緒申鐃叔わ申鐃祝￥申 statement_timestamp()鐃緒申鐃緒申鐃�transaction_timestamp()鐃熟トワ申鵐競鐃緒申鐃緒申鐃緒申虜能鐃塾ワ申鐃殉ワ申匹任鐃銃縁申鐃緒申佑鐃緒申屬鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申慮鐃祝逸申鐃緒申続鐃緒申鐃緒申鐃殉ワ申匹任楼曚覆鐃緒申能鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃� clock_timestamp()鐃熟実際の醐申鐃淳誌申鐃緒申鐃緒申屬鐃緒申泙鐃緒申里如鐃緒申鐃緒申鐃緒申佑鐃獣縁申鐃緒申SQL鐃緒申鐃殉ワ申匹任鐃緒申辰討鐃循なわ申泙鐃緒申鐃� timeofday()鐃緒申PostgreSQL鐃緒申鐃緒申鐃重�鐃淑関随申鐃叔わ申鐃緒申 clock_timestamp()同鐃粛￥申鐃渋際の醐申鐃淳誌申鐃緒申鐃緒申屬鐃緒申泙鐃緒申鐃緒申鐃�timestamp with time zone鐃緒申鐃緒申鐃粛ではなわ申鐃緒申鐃緒申鐃緒申鐃緒申鐃曙たtext文鐃緒申鐃緒申鐃緒申屬鐃緒申泙鐃緒申鐃�now()鐃緒申transaction_timestamp()鐃緒申同鐃緒申鐃緒申里如鐃緒申鐃緒申鐃重�鐃緒申PostgreSQL鐃舜随申鐃叔わ申鐃緒申

鐃緒申鐃駿てわ申鐃緒申鐃緒申/鐃緒申鐃緒型鐃熟まわ申鐃緒申鐃緒申鐃淳わ申鐃緒申鐃春と誌申鐃緒申雰鐃緒申鐃緒申屬鐃緒申泙鐃緒申鐃緒申肇鐃藷ザワ申鐃緒申鐃緒申鐃塾鰹申鐃熟誌申鐃緒申箸鐃緒申堂鐃潤さ鐃緒申泙鐃緒申砲鐃宿緒申鐃緒申端鐃淑ワ申謄鐃緒申鐃緒申 now鐃緒申鐃緒申鐃緒申佞鐃緒申泙鐃緒申鐃� 鐃緒申鐃緒申鐃緒申鐃獣て￥申鐃緒申鐃緒申鐃塾ｏ申鐃縦の実行件申未鐃緒申鐃緒申鐃銃縁申鐃緒申鐃塾となわ申泙鐃緒申鐃� 

SELECT CURRENT_TIMESTAMP;
SELECT now();
SELECT TIMESTAMP 'now';  -- incorrect for use with DEFAULT

鐃銃ワ申鐃獣ワ申: 鐃銃￥申鐃瞬ワ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃�DEFAULT鐃緒申鐃緒申鐃所す鐃緒申里鐃�3鐃緒申鐃旬の件申鐃緒申鐃緒申箸鐃緒申鐃緒申箸六廚鐃淑わ申鐃叔わ申鐃順う鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申呂鐃緒申譴随申鐃緒申鐃緒申鐃緒申鐃緒申謄爐�now鐃緒申timestamp鐃緒申鐃術器申鐃緒申鐃緒申里如鐃緒申妊侫鐃緒申鐃緒申鐃粛とわ申鐃銃テ￥申鐃瞬ルが鐃緒申鐃緒申鐃緒申鐃曙た鐃緒申鐃緒が鐃夙わ申鐃殉わ申鐃緒申鐃叔緒申鐃�2鐃縦の件申鐃緒申鐃熟関随申鐃銃び出わ申鐃塾わ申鐃緒申妊侫鐃緒申鐃緒申鐃粛わ申鐃緒申鐃術わ申鐃緒申鐃殉わ申評鐃緒申鐃緒申鐃緒申泙鐃緒申鵝�でわ申鐃緒申鐃初、鐃緒申鐃緒申鐃塾関随申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申屬鐃叔フワ申鐃緒申箸箸鐃緒申襦∨常申泙鐃緒申鐃緒申鐃緒申颪い鬚靴泙鐃緒申鐃�

9.9.5. 鐃駿縁申孫鐃�

鐃淑駕申鐃塾関随申鐃熟￥申鐃緒申鐃緒申鐃出プワ申鐃緒申鐃緒申鐃塾実行わ申鐃駿延さ鐃緒申鐃暑た鐃緒申忙鐃緒申儔鐃叔緒申任鐃緒申鐃� 

pg_sleep(seconds)

pg_sleep鐃熟￥申seconds鐃獣経過す鐃緒申泙如鐃緒申鐃緒申澆離鐃緒申奪鐃緒申鐃緒申離廛鐃緒申鐃緒申鐃緒申鐃駿止わ申鐃緒申鐃殉わ申鐃緒申seconds鐃緒申double precision鐃緒申鐃緒申鐃粛でわ申鐃緒申 鐃緒申鐃塾わ申鐃潤、鐃緒申鐃緒申単鐃縮で休誌申鐃獣随申鐃緒申鐃緒申蠅刻申襪鰹申箸鐃緒申任鐃緒申泙鐃緒申鐃緒申焚鐃緒申鐃緒申鐃薯示わ申鐃殉わ申鐃緒申 

SELECT pg_sleep(1.5);

鐃緒申鐃緒申: 鐃駿止誌申鐃瞬わ申有鐃緒申鐃緒申分鐃緒申能鐃熟プワ申奪肇侫鐃緒申鐃緒申鐃祝逸申存鐃緒申鐃殉わ申鐃緒申0.01鐃獣わ申鐃緒申鐃緒申的鐃緒申鐃粛でわ申鐃緒申鐃駿縁申肋鐃緒申覆鐃緒申箸鐃緒申鐃所し鐃緒申鐃縮わ申圓鐃緒申泙鐃緒申鐃緒申鐃緒申鐃緒申个鐃緒申鐃駿わ申鐃竣逸申鐃夙なり、鐃緒申鐃縦刻申鐃緒申覆鐃緒申能鐃緒申鐃緒申鐃緒申鐃緒申泙鐃緒申鐃�

鐃駿刻申

pg_sleep鐃緒申討喀个鐃緒申鐃緒申鐃緒申鐃緒申奪鐃緒申鐃緒申必鐃竣以常申離鐃緒申奪鐃緒申鐃緒申飮鐃緒申鐃緒申討鐃緒申覆鐃緒申鐃緒申箸鐃塾実にわ申鐃銃わ申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申覆鐃緒申函鐃渋常申離鐃緒申奪鐃緒申鐃藷が休誌申鐃緒申離廛鐃緒申鐃緒申鐃緒申鐃緒申垉鐃緒申鐃緒申覆鐃緒申鐃出なわ申覆鐃緒申鐃緒申發件申鐃殉わ申鐃藷。わ申鐃塾わ申鐃潤シ鐃緒申鐃銃ワ申鐃緒申鐃塾わ申速鐃駿わ申鐃純下鐃緒申鐃暑こ鐃夙になるか鐃盾し鐃緒申泙鐃緒申鐃�

鐃緒申鐃緒申

[1]

鐃緒申鐃准レー鐃銃ワ申鐃藷グワ申鐃緒申鐃銃ワ申任鐃緒申襪�鐃獣わ申鐃緒申鐃緒申鐃緒申鐃緒申討鐃緒申鐃緒申鐃緒申60鐃殉で￥申

鐃緒申鐃塾ペ￥申鐃緒申鐃循￥申鐃緒申鐃緒申鐃塾ペ￥申鐃緒申
鐃叔￥申鐃緒申鐃緒申鐃緒申鐃緒申鐃緒申愎鐃�鐃緒申鐃緒申鐃緒申鐃緒申鷏織鐃緒申檗鐃緒申抜愎鐃�