| PostgreSQL 8.1.9ʸ½ñ | ||||
|---|---|---|---|---|
| Á°¤Î¥Ú¡¼¥¸ | ´¬Ìᤷ | Âè 8¾Ï¥Ç¡¼¥¿·¿ | ÁáÁ÷¤ê | ¼¡¤Î¥Ú¡¼¥¸ |
PostgreSQL¤Ç¤Ï¡¢É½8-9¤Ë¼¨¤µ¤ì¤Æ¤¤¤ëSQL¤ÎÆüÉդȻþ¹ï¥Ç¡¼¥¿·¿¤ÎÁ´¤Æ¤¬¥µ¥Ý¡¼¥È¤µ¤ì¤Æ¤¤¤Þ¤¹¡£ ¤³¤ì¤é¤Î¥Ç¡¼¥¿·¿¤ÇÍøÍѤǤ¤ë±é»»»Ò¤Ë¤Ä¤¤¤Æ¤Ï¹à9.9¤ÇÀâÌÀ¤·¤Þ¤¹¡£
ɽ 8-9. ÆüÉÕ/»þ¹ï¥Ç¡¼¥¿·¿
| ·¿Ì¾ | ³ÊǼ¥µ¥¤¥º | ÀâÌÀ | ºÇ±ó¤Î²áµî | ºÇ±ó¤Î̤Íè | ÀºÅÙ |
|---|---|---|---|---|---|
| timestamp [ (p) ] [ without time zone ] | 8 ¥Ð¥¤¥È | ÆüÉդȻþ¹ïξÊý | 4713 BC | 5874897 AD | 1¦ÌÉá¢14·å |
| timestamp [ (p) ] with time zone | 8¥Ð¥¤¥È | ÆüÉդȻþ¹ïξÊý¡¢»þ´ÖÂÓÉÕ¤ | 4713 BC | 5874897 AD | 1¦ÌÉá¢14·å |
| interval [ (p) ] | 12¥Ð¥¤¥È | »þ´Ö´Ö³Ö | -178000000ǯ | 178000000ǯ | 1¦ÌÉá¢14·å |
| date | 4¥Ð¥¤¥È | ÆüÉÕ¤Î¤ß | 4713 BC | 5874897 AD | 1Æü |
| time [ (p) ] [ without time zone ] | 8¥Ð¥¤¥È | ¤½¤ÎÆü¤Î»þ¹ï¤Î¤ß | 00:00:00.00 | 24:00:00 | 1¦ÌÉá¢14·å |
| time [ (p) ] with time zone | 12¥Ð¥¤¥È | ¤½¤ÎÆü¤Î»þ¹ï¤Î¤ß¡¢»þ´ÖÂÓÉÕ¤ | 00:00:00.00+12 | 23:59:59.99-12 | 1¦ÌÉá¢14·å |
Ãí°Õ: PostgreSQL 7.3¤è¤ê°ÊÁ°¤Ç¤Ï¡¢Ã±¤Ê¤ëtimestamp¤Ïtimestamp with time zone¤ÈƱ¤¸¤Ç¤·¤¿¡£ ¤³¤ì¤Ï¡¢SQL¸ß´¹À¤Î¤¿¤á¤ËÊѹ¹¤µ¤ì¤Þ¤·¤¿¡£
time¡¢timestamp¡¢¤ª¤è¤Óinterval¤ÏÉÃ¥Õ¥£¡¼¥ë¥É¤ËÊÝͤµ¤ì¤Æ¤¤¤ë¾®¿ôÅÀ°Ê²¼¤Î·å¿ô¤ò»ØÄꤹ¤ë¥ª¥×¥·¥ç¥ó¤ÎÀºÅÙÃͤǤ¢¤ëp¤ò¼õ¤±ÉÕ¤±¤Þ¤¹¡£ ¥Ç¥Õ¥©¥ë¥È¤Ç¤Ï¡¢ÌÀ¼¨Åª¤ÊÀºÅÙ¤ËÂФ¹¤ë¸Â³¦¤Ï¤¢¤ê¤Þ¤»¤ó¡£ p¤ÎµöÍÆÈϰϤϡ¢timestamp·¿¤Èinterval·¿¤Î¾ì¹ç¤Ï0¤«¤é6¤Ç¤¹¡£
Ãí°Õ: timestamp¤ÎÃͤ¬ÇÜÀºÅÙÉâÆ°¾®¿ôÅÀ¿ô¤È¤·¤ÆÊݸ¤µ¤ì¤Æ¤¤¤ë¾ì¹ç¡Ê¸½ºß¤Î¥Ç¥Õ¥©¥ë¥È¤Ç¤¹¡Ë¡¢Í¸ú¤ÊÀºÅÙ¤Ï6¤è¤ê¾®¤µ¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¡£ timestamp¤ÎÃͤÏ2000-01-01¿¼Ìë¤ò´ð½à¤Ë¤·¤¿·Ð²áÉÿô¤È¤·¤Æ³ÊǼ¤µ¤ì¤Þ¤¹¡£ ¥Þ¥¤¥¯¥íÉäÎÀºÅ٤ϡ¢2000-01-01¤«¤é2¡¢3ǯ°ÊÆâ¤ÎÆüÉդǤÏãÀ®¤µ¤ì¤Æ¤¤¤Þ¤¹¤¬¡¢¤½¤ÎÀºÅÙ¤ÏÆüÉÕ¤¬¡Ê2000-01-01¤«¤é¡ËÎ¥¤ì¤ë¤Ë¤Ä¤ì¤Æ°²½¤·¤Þ¤¹¡£ timestamp¤ÎÃͤ¬8¥Ð¥¤¥ÈÀ°¿ô¡Ê¥³¥ó¥Ñ¥¤¥ë»þ¤Ë¥ª¥×¥·¥ç¥ó»ØÄê¡Ë¤È¤·¤Æ³ÊǼ¤µ¤ì¤ë»þ¤Ë¤Ï¥Þ¥¤¥¯¥íÉäÎÀºÅÙ¤ÏÁ´¤Æ¤ÎÈϰϤÎÃͤ˴ؤ·¤Æ͸ú¤Ç¤¹¡£ ¤·¤«¤·¡¢8¥Ð¥¤¥ÈÀ°¿ô¤Î¥¿¥¤¥à¥¹¥¿¥ó¥×¤Ç¤Ï¡¢¤½¤ÎÆüÉÕÈϰϤ¬¾å½Ò¤ÎÀ©¸Â¤è¤ê¤âÀ©¸Â¤µ¤ì¡¢4713 BC¤«¤é294276 AD¤Þ¤Ç¤È¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ Ʊ¤¸¥³¥ó¥Ñ¥¤¥ë¥ª¥×¥·¥ç¥ó¤Ç¡¢time¤ª¤è¤ÓintervalÃͤòÉâÆ°¾®¿ôÅÀ¿ô¤È¤·¤Æ³ÊǼ¤¹¤ë¤«8¥Ð¥¤¥ÈÀ°¿ô¤È¤·¤Æ³ÊǼ¤¹¤ë¤«¤â·è¤Þ¤ê¤Þ¤¹¡£ ÉâÆ°¾®¿ôÅÀ¿ô¤Î¾ì¹ç¡¢Â礤Êinterval¤Ç¤Ï´Ö³Ö¤¬Áý²Ã¤¹¤ëºÝ¤ËÀºÅÙ¤¬Íî¤Á¤Þ¤¹¡£
time·¿¤Ç8¥Ð¥¤¥ÈÀ°¿ô¤¬»ÈÍѤµ¤ì¤¿¾ì¹ç¤Ë¤Ï¡¢p¤Ï0¤«¤é6¤Þ¤Ç¤ÎÈϰϤǻÈÍѲÄǽ¤Ç¤¹¡£ ¤Þ¤¿¡¢ÉâÆ°¾®¿ôÅÀ¤¬»ÈÍѤµ¤ì¤ë¾ì¹ç¤Ë¤Ï0¤«¤é10¤Þ¤Ç¤¬»ÈÍѲÄǽ¤Ç¤¹¡£
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.5¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£ SQL¤Ç¤Ï²¼µ¤Î¹½Ê¸¤¬É¬ÍפǤ¹¡£
type [ (p) ] 'value'
¤³¤³¤Ç¡¢¥ª¥×¥·¥ç¥ó¤ÎÀºÅ٤λØÄêp¤ÏÉÃ¥Õ¥£¡¼¥ë¥É¤Î¾®¿ôÅÀ°Ê²¼¤Î·å¿ô¤ËÂбþ¤¹¤ëÀ°¿ô¤Ç¤¹¡£ ÀºÅÙ¤Ïtime¡¢timestamp¡¢¤ª¤è¤Óinterval·¿¤ËÂФ·¤ÆÀßÄê¤Ç¤¤Þ¤¹¡£ ÃͤεöÍÆÈϰϤϴû¤ËÀâÌÀ¤·¤Æ¤¤¤Þ¤¹¡£ Äê¿ô»ØÄê¤Ë¤ª¤¤¤ÆÀºÅÙ»ØÄ꤬¤Ê¤¤¾ì¹ç¤Ï¡¢¥Ç¥Õ¥©¥ë¥È¤Î¥ê¥Æ¥é¥ëÃͤÎÀºÅ٤ˤʤê¤Þ¤¹¡£
ɽ8-10¤Ïdate·¿¤ÇÆþÎϲÄǽ¤Ê¤â¤Î¤Î°ìÉô¤ò¼¨¤·¤Þ¤¹¡£
ɽ 8-10. ÆüÉÕÆþÎÏ
| Îã | ÀâÌÀ |
|---|---|
| January 8, 1999 | Á´¤Æ¤ÎdatestyleÆþÎϥ⡼¥É¤Ë¤ª¤¤¤ÆÛ£Ë椵¤¬¤¢¤ê¤Þ¤»¤ó¡£ |
| 1999-01-08 | ISO 8601¡£Á´¤Æ¤Î¥â¡¼¥É¤Ç1·î8Æü¤Ë¤Ê¤ê¤Þ¤¹¡Ê¿ä¾©½ñ¼°¡Ë¡£ |
| 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¤Ø¤ÎÆþÎϤ˻þ´ÖÂÓ¤¬»ØÄꤵ¤ì¤¿¾ì¹ç¡¢»þ´ÖÂӤϷٹð¤Ê¤¯Ìµ»ë¤µ¤ì¤Þ¤¹¡£
ɽ 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 | ̾Á°¤Ë¤è¤ë»þ´ÖÂӤλØÄê¡£ |
ɽ 8-12. »þ´ÖÂÓÆþÎÏ
| Îã | ÀâÌÀ |
|---|---|
| PST | ÊƹñÂÀÊ¿ÍÎɸ½à»þ´Ö |
| -8:00 | ISO 8601¡£PSTÍѤΥª¥Õ¥»¥Ã¥È |
| -800 | ISO 8601¡£PSTÍѤΥª¥Õ¥»¥Ã¥È |
| -8 | ISO 8601¡£PSTÍѤΥª¥Õ¥»¥Ã¥È |
| zulu | UTCÍѤη³»öÍÑάµ |
| z | zulu¤Îάµ |
ÆþÎÏÍѤËǧ¼±²Äǽ¤Ê»þ´ÖÂÓ̾¾Î¤Î°ìÍ÷¤Ë¤Ä¤¤¤Æ¤ÏÉÕÏ¿B¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£
¥¿¥¤¥à¥¹¥¿¥ó¥×·¿¤Ø¤Î͸ú¤ÊÆþÎϤϡ¢ÆüÉդȻþ¹ï¤ò¥»¥Ã¥È¤Ë¤·¤¿¤â¤Î¡¢¤µ¤é¤Ë¤½¤Î¸å¤Ë¥ª¥×¥·¥ç¥ó¤Ç»þ´ÖÂÓ¡¢¤½¤Î¸å¤Ë¥ª¥×¥·¥ç¥ó¤Ç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 with time zone¤Î¥ê¥Æ¥é¥ë¤Ë¤ÏÌÀ¼¨Åª¤Ê·¿ÉÕ¤±¡¢Î㤨¤Ð¡¢
TIMESTAMP WITH TIME ZONE '2004-10-19 10:23:54+02'
¤¬É¬ÍפǤ¹¡£ timestamp with 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¤ò»ÈÍѤ¹¤ëÊÑ´¹¤Ç¤Ï¡¢°Û¤Ê¤ë»þ´ÖÂÓ»²¾È¤ò»ØÄê¤Ç¤¤Þ¤¹¡£
interval¤ÎÃͤϰʲ¼¤Î¹½Ê¸¤Ç½ñ¤¯¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
[@] quantity unit [quantity unit...] [direction]
¤³¤³¤Ç¡¢quantity¤Ï¡ÊÉä¹æÉÕ¤¡Ë»þ´ÖÎÌ¡¢unit¡Êñ°Ì¡Ë¤Ïsecond¡ÊÉáˡ¢minute¡Êʬ¡Ë¡¢hour¡Ê»þ¡Ë¡¢day¡ÊÆü¡Ë¡¢week¡Ê½µ¡Ë¡¢month¡Ê·î¡Ë¡¢year¡Êǯ¡Ë¡¢decade¡Ê10ǯñ°Ì¡Ë¡¢century¡Ê100ǯñ°Ì¡Ë¡¢millennium¡Ê1000ǯñ°Ì¡Ë¤¢¤ë¤¤¤Ï¤³¤ì¤é¤Îñ°Ì¤Î´Êά·Á¤Þ¤¿¤ÏÊ£¿ô·Á¤Ç¤¹¡£ direction¡ÊÊý¸þ¡Ë¤Ïago¤â¤·¤¯¤Ï¶õ¤Ç¤¹¡£ ¥¢¥Ã¥È¥Þ¡¼¥¯¡Ê@¡Ë¤Ï¥ª¥×¥·¥ç¥ó¤Ç¡¢ÉÕ¤±¤Æ¤âÉÕ¤±¤Ê¤¯¤Æ¤â¹½¤¤¤Þ¤»¤ó¡£ °Û¤Ê¤ëñ°Ì¤Ë¤ª¤±¤ë»þ´ÖÎ̤ÏŬÀÚ¤ËÉä¹æ¤ò¹Íθ¤·¤Æ°ÅÌÛŪ¤Ë¤µ¤ì¤Þ¤¹¡£
Æü¡¢»þ¡¢Ê¬¡¢¤ª¤è¤ÓÉäλþ´ÖÎ̤ÏÌÀ¼¨Åª¤Ëñ°Ì¤ò»ØÄꤷ¤Ê¤¯¤Æ¤â¹½¤¤¤Þ¤»¤ó¡£ Î㤨¤Ð¡¢'1 12:59:10'¤Ï'1Æü¤È12»þ´Ö59ʬ10ÉÃ'¤È²ò¼á¤µ¤ì¤Þ¤¹¡£
Éðʲ¼¤Î¥ª¥×¥·¥ç¥ó¤ÎÀºÅÙp¤Ï0¤«¤é6¤Þ¤Ç¤ÎÈϰϤǡ¢¥Ç¥Õ¥©¥ë¥È¤ÏÆþÎÏ¥ê¥Æ¥é¥ë¤ÎÀºÅ٤Ǥ¹¡£
ÆâÉôŪ¤Ë¤Ï¡¢interval¤ÎÃͤϷî¿ô¡¢Æü¿ô¤ª¤è¤ÓÉÿô¤È¤·¤Æ³ÊǼ¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¤¢¤ë·î¤ÎÆü¿ô¤Ï·î¤Ë¤è¤Ã¤ÆÊѤï¤ê¤Þ¤¹¤·¡¢²Æ»þ´Ö¤¬Æ³Æþ¤µ¤ì¤Æ¤¤¤ë¤È1Æü¤¬23»þ´Ö¤Ç¤¢¤Ã¤¿¤ê25»þ´Ö¤Ç¤¢¤Ã¤¿¤ê¤¹¤ë¤«¤é¤Ç¤¹¡£»þ´Ö´Ö³Ö¤ÏÄ̾ïÄê¿ôÎ󡢤⤷¤¯¤Ïtimestamp¤«¤é¤Î°ú¤»»¤ÇÀ¸À®¤µ¤ì¤Þ¤¹¤Î¤Ç¡¢¤³¤ÎÍͤËÊݸ¤¹¤ì¤Ð¤Û¤È¤ó¤É¤Î¾ì¹ç¤¦¤Þ¤¯¹Ô¤¤Þ¤¹¡£justify_days¤Èjustify_hours´Ø¿ô¤ÇÄ̾ï¤ÎÈϰϤò±Û¤¨¤¿Æü¤Ë¤Á¤È»þ¹ï¤òÄ´À°¤Ç¤¤Þ¤¹¡£
PostgreSQL¤Ç¤ÏÍøÊØÀ¤Î¤¿¤á¤Ë¡¢É½8-13¤Ë¼¨¤µ¤ì¤Æ¤¤¤ë¤è¤¦¤ÊÆÃÊ̤ÊÆüÉÕ/»þ¹ïÆþÎÏÃͤò¥µ¥Ý¡¼¥È¤·¤Æ¤¤¤Þ¤¹¡£ infinity¤È-infinity¤ÎÃͤϡ¢ÆÃÊ̤˥·¥¹¥Æ¥àÆâÉô¤Çɽ¸½¤µ¤ì¡¢Æ±¤¸¤è¤¦¤Ëɽ¼¨¤µ¤ì¤Þ¤¹¡£ ¾¤Î¤â¤Î¤Ï¡¢Ã±¤Ë´Êά²½¤µ¤ì¤¿É½µ¤Ç¡¢Æɤ߹þ¤Þ¤ì¤ëºÝ¤Ë¤ÏÄ̾ï¤ÎÆüÉÕ/»þ¹ïÃͤËÊÑ´¹¤µ¤ì¤Þ¤¹ ¡ÊÆäËnow¤È¤½¤Î´ØϢʸ»úÎó¤ÏÆɤ߹þ¤Þ¤ì¤ë¤È¤¹¤°¤Ë¤½¤Î»þÅÀ¤ÎÃͤËÊÑ´¹¤µ¤ì¤Þ¤¹¡Ë¡£ ¤³¤ì¤é¤ÎÃͤÏÁ´¤Æ¡¢SQL¥³¥Þ¥ó¥É¤ÇÄê¿ô¤È¤·¤Æ»È¤¦¾ì¹ç¤Ï¡¢Ã±°ì°úÍÑÉä¤Ç³ç¤é¤Ê¤±¤ì¤Ð¤Ê¤ê¤Þ¤»¤ó¡£
ɽ 8-13. Æüì¤ÊÆüÉÕ/»þ¹ïÄê¿ô
| ÆþÎÏʸ»úÎó | ͸ú¤Ê·¿ | ÀâÌÀ |
|---|---|---|
| epoch | date, timestamp | 1970-01-01 00:00:00+00¡ÊUnix¥·¥¹¥Æ¥à»þ´Ö¤Ë¤ª¤±¤ë¥¼¥í¡Ë |
| infinity | timestamp | ¾¤ÎÁ´¤Æ¤Î¥¿¥¤¥à¥¹¥¿¥ó¥×¤è¤êÃÙ¤¤ |
| -infinity | 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´Ø¿ô¤Ç¤¢¤ê¡¢¥Ç¡¼¥¿ÆþÎÏʸ»úÎó¤È¤·¤Æ¤Ïǧ¼±¤µ¤ì¤Ê¤¤¤³¤È¤ËÃí°Õ¤·¤Æ¤¯¤À¤µ¤¤¡£
ÆüÉÕ/»þ¹ï·¿¤Î½ÐÎϽñ¼°¤Ï¡¢SET datestyle¥³¥Þ¥ó¥É¤ò»ÈÍѤ·¤Æ¡¢ISO 8601¡¢SQL¡ÊIngres¡Ë¡¢ÅÁÅýŪ¤ÊPOSTGRES¡¢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 |
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 |
interval¤Î½ÐÎϤÏcentury¤äweek¤È¤¤¤Ã¤¿Ã±°Ì¤¬Ç¯¤ÈÆü¤ËÊÑ´¹¤µ¤ì¤ëÅÀ¤Èago¤¬Å¬ÀÚ¤ÊÉä¹æ¤ËÊÑ´¹¤µ¤ì¤ëÅÀ¤ò½ü¤¡¢ÆþÎϽñ¼°¤ÈƱ¤¸¤è¤¦¤Ëɽ¸½¤µ¤ì¤Þ¤¹¡£ ISO¥â¡¼¥É¤Ç¤Î½ÐÎϤϰʲ¼¤Î¤è¤¦¤Ë¤Ê¤ê¤Þ¤¹¡£
[quantity unit [ ... ] ] [ days ] [ hours:minutes:seconds ]
¥æ¡¼¥¶¤ÏSET DATESTYLE¥³¥Þ¥ó¥É¡¢postgresql.conf¹½À®¥Õ¥¡¥¤¥ë¤ÎDateStyle¥Ñ¥é¥á¡¼¥¿¡¢¤½¤·¤Æ¥µ¡¼¥Ð¤«¥¯¥é¥¤¥¢¥ó¥È¤ÎPGDATESTYLE´Ä¶ÊÑ¿ô¤ò»ÈÍѤ·¤Æ¡¢ÆüÉÕ/»þ¹ï¤ÎÍͼ°¤òÁªÂò¤¹¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£
ÆüÉÕ/»þ¹ï½ÐÎϤΤè¤ê½ÀÆð¤Ê½ñ¼°ÀßÄêÊýË¡¤È¤·¤Æ¡¢½ñ¼°ÀßÄê´Ø¿ôto_char¡Ê¹à9.8¤ò»²¾È¡Ë¤ò»ÈÍѤ¹¤ë¤³¤È¤â¤Ç¤¤Þ¤¹¡£
»þ´ÖÂÓ¤ª¤è¤Ó»þ´ÖÂӤμè¤ê·è¤á¤ÏÃϵå¤Î´ö²¿³ØŪÍ×ÁǤΤߤǤʤ¯À¯¼£ÅªÈ½ÃǤ˱ƶÁ¤µ¤ì¤Þ¤¹¡£ À¤³¦¤Ë¤Þ¤¿¤¬¤ë»þ´ÖÂÓ¤Ï1900ǯÂå¤Ëɸ½à²½¤µ¤ì¤¿¤è¤¦¤Ç¤¹¤¬¡¢Æä˲ƻþ´Öµ¬Â§¤ÎÅÀ¤Ç¡¢¾¡¼ê¤ËÊѹ¹¤¹¤ë·¹¸þ¤¬Â³¤¤¤Æ¤¤¤Þ¤¹¡£ PostgreSQL¤Ï¸½ºß¡¢¡ÊÅÁÅýŪ¤ÊUnix¥·¥¹¥Æ¥à»þ´Ö¤ÎÈϰϤ˰ìÃפ¹¤ë¡Ë1902ǯ¤«¤é2038ǯ¤Þ¤Ç¤Î´ü´Ö¤Ë¤Ä¤¤¤Æ²Æ»þ´Öµ¬Â§¤ò¥µ¥Ý¡¼¥È¤·¤Þ¤¹¡£ Èϰϳ°¤ÎÆüÉÕ/»þ¹ï¤ÏÁªÂò¤µ¤ì¤¿»þ´ÖÂÓ¤Î"ɸ½à»þ´Ö"¤Çɽ¤µ¤ì¤¿¤â¤Î¤È¤ß¤Ê¤·¤Þ¤¹¡£ ¤Ä¤Þ¤ê¡¢²¿Ç¯¤Ë¤Ê¤Ã¤¿¤é¼ºÇÔ¤¹¤ë¤È¤¤¤¦¤³¤È¤ò¿´ÇÛ¤¹¤ëɬÍפϤ¢¤ê¤Þ¤»¤ó¡£
PostgreSQL¤ÏÈÆÍÑŪ¤Ë»ÈÍѤǤ¤ë¤è¤¦¤Ëɸ½àSQL¤Ø¤Î¸ß´¹À¤ËÂФ·ºÇÂç¸Â¤ÎÅØÎϤò¤·¤Æ¤¤¤Þ¤¹¡£ ¤·¤«¤·¡¢É¸½àSQL¤Ë¤Ï¡¢ÆüÉդȻþ¹ï¤Î¥Ç¡¼¥¿·¿¤Èµ¡Ç½¤Ë´Ø¤¹¤ëº®Í𤬸«¼õ¤±¤é¤ì¤Þ¤¹¡£ 2¤Ä¤ÎÌÀ¤é¤«¤ÊÌäÂêÅÀ¤ò°Ê²¼¤Ë¼¨¤·¤Þ¤¹¡£
date·¿¤Ë¤Ï¤½¤ì¤Ë´ØÏ¢¤¹¤ë»þ´ÖÂÓ¤¬¤¢¤ê¤Þ¤»¤ó¤¬¡¢time·¿¤Ë¤Ï¤¢¤ê¤Þ¤¹¡£ ¸½¼Â¤ÎÀ¤³¦¤Ë¤ª¤¤¤Æ¡¢»þ´ÖÂӤΥª¥Õ¥»¥Ã¥È¤¬²Æ»þ´Ö¤Ø¤ÎÀÚ¤êÂؤ¨¤Ë¤è¤êǯ´Ö¤òÄ̤¸¤ÆÊѲ½¤¹¤ë¤³¤È¤«¤é¡¢»þ¹ï¤ÈƱÍͤËÆüÉդ⤽¤ì¤Ë·ë¤ÓÉÕ¤±¤é¤ì¤Æ¤¤¤Ê¤¤¤È°ÕÌ£¤¬¤¢¤ê¤Þ¤»¤ó¡£
¥Ç¥Õ¥©¥ë¥È¤Î»þ´ÖÂÓ¤ÏUTC¤«¤é¤ÎÀ°¿ôÄê¿ô¥ª¥Õ¥»¥Ã¥È¤È¤·¤Æ»ØÄꤵ¤ì¤Æ¤¤¤Þ¤¹¡£ ¤·¤¿¤¬¤Ã¤ÆDST¡Ê²Æ»þ´Ö¡Ë¤Ø¤ÎÀÚ¤êÂؤ¨¤ò¤Þ¤¿¤¤¤ÇÆüÉÕ/»þ¹ï±é»»¤ò¹Ô¤¦¾ì¹ç¡¢²Æ»þ´Ö¤òŬÍѤ¹¤ë¤³¤È¤Ï¤Ç¤¤Þ¤»¤ó¡£
¤³¤Î¤è¤¦¤ÊÌäÂê¤ò²ò·è¤¹¤ë¤¿¤á¤Ë¤Ï¡¢»þ´ÖÂÓ¤ò»ÈÍѤ¹¤ëºÝ¤ËÆüÉդȻþ¹ï¤ÎξÊý¤òÊÝ»ý¤Ç¤¤ëÆüÉÕ/»þ¹ï¥Ç¡¼¥¿·¿¤ò»ÈÍѤ¹¤ë¤³¤È¤ò´«¤á¤Þ¤¹¡£ time with time zone·¿¤Î»ÈÍѤϤª´«¤á¤·¤Þ¤»¤ó ¡Ê¤â¤Ã¤È¤âPostgreSQL¤Ç¤Ï¡¢µì¼°¤Î¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤ä¡¢É¸½àSQL¤È¤Î¸ß´¹À¤Î¤¿¤á¤Ë¡¢time with time zone·¿¤Î»ÈÍѤò¥µ¥Ý¡¼¥È¤·¤Æ¤¤¤Þ¤¹¡Ë¡£ PostgreSQL¤Ï¡¢ÆüÉÕ¤Þ¤¿¤Ï»þ¹ï¤Î¤ß¤òÊÝ»ý¤¹¤ë¥Ç¡¼¥¿·¿¤ÎÁ´¤Æ¤Ï»ÈÍÑÃæ¤Î»þ´ÖÂӤǤ¢¤ë¤ÈÁ°Ä󤷤Ƥ¤¤Þ¤¹¡£
Á´¤Æ¤Î»þ´ÖÂÓÉÕ¤¤ÎÆüÉդȻþ¹ï¤ÏUTC¤ÇÆâÉôŪ¤ËÊݸ¤µ¤ì¤Þ¤¹¡£ ¤³¤ì¤é¤Ï¥¯¥é¥¤¥¢¥ó¥È¤Ëɽ¼¨¤µ¤ì¤ëÁ°¤ËtimezoneÀßÄê¥Ñ¥é¥á¡¼¥¿¤Ç»ØÄꤵ¤ì¤¿»þ´ÖÂӤˤª¤±¤ë¥í¡¼¥«¥ë»þ´Ö¤ËÊÑ´¹¤µ¤ì¤Þ¤¹¡£
timezone¤Ïpostgresql.conf¥Õ¥¡¥¤¥ë¤äÂè17¾Ï¤ÇÀâÌÀ¤¹¤ë¾¤Îɸ½àŪ¤ÊÊýË¡¤ÇÀßÄꤹ¤ë¤³¤È¤¬¤Ç¤¤Þ¤¹¡£ °Ê²¼¤Ë¡¢¤¤¤¯¤Ä¤«ÆÃÊ̤ÊÀßÄêÊýË¡¤ò¼¨¤·¤Þ¤¹¡£
postgresql.confÆâ¤äpostmaster¤Î¥³¥Þ¥ó¥É¥é¥¤¥ó¥¹¥¤¥Ã¥Á¤Çtimezone¤¬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¡¢¥Ç¥Õ¥©¥ë¥È¤Î»þ´ÖÂӤȤ·¤ÆTZ´Ä¶ÊÑ¿ô¤ÎÃͤò»ÈÍѤ·¤è¤¦¤È»î¤ß¤Þ¤¹¡£
TZ¤¬ÄêµÁ¤µ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤äTZ¤¬PostgreSQL¤Çǧ¼±²Äǽ¤Ê»þ´ÖÂÓ̾¾Î¤Ç¤Ê¤«¤Ã¤¿¾ì¹ç¡¢¥µ¡¼¥Ð¤Ï¡¢localtime()C¥é¥¤¥Ö¥é¥ê´Ø¿ô¤ÎÆ°ºî¤ò¸¡ºº¤¹¤ë¤³¤È¤Ç¥ª¥Ú¥ì¡¼¥Æ¥£¥ó¥°¥·¥¹¥Æ¥à¤Î¥Ç¥Õ¥©¥ë¥È¤Î»þ´ÖÂÓ¤ò·èÄꤷ¤è¤¦¤È»î¤ß¤Þ¤¹¡£
¤³¤Î¥Ç¥Õ¥©¥ë¥È¤Î»þ´ÖÂӤϡ¢PostgreSQL¤¬Ç§¼±²Äǽ¤Ê»þ´ÖÂÓ¤ÎÃ椫¤éºÇ¤â¶á¤¤¤â¤Î¤¬ÁªÂò¤µ¤ì¤Þ¤¹¡£
SET TIME ZONE SQL¥³¥Þ¥ó¥É¤Ï¥»¥Ã¥·¥ç¥ó¤Î»þ´ÖÂÓ¤òÀßÄꤷ¤Þ¤¹¡£ ¤³¤ì¤ÏSQL»ÅÍ͸ߴ¹¤Îʸˡ¤Ë¤è¤ê½¾¤Ã¤Æ¤¤¤ëSET TIMEZONE TO¤ÎÊÌ̾¤Ç¤¹¡£
¥¯¥é¥¤¥¢¥ó¥È¤Ë¤è¤Ã¤ÆPGTZ´Ä¶ÊÑ¿ô¤¬ÀßÄꤵ¤ì¤Æ¤¤¤ë¾ì¹ç¡¢Àܳ³ÎΩ»þ¤Ë¥µ¡¼¥Ð¤ËÂФ·SET TIME ZONE¥³¥Þ¥ó¥É¤òlibpq¥¢¥×¥ê¥±¡¼¥·¥ç¥ó¤¬Á÷¿®¤·¤Þ¤¹¡£
»ÈÍѲÄǽ¤Ê»þ´ÖÂӤˤĤ¤¤Æ¤Ï¡¢ÉÕÏ¿B¤ò»²¾È¤·¤Æ¤¯¤À¤µ¤¤¡£
PostgreSQL¤ÏÁ´¤Æ¤ÎÆüÉդȻþ¹ï¤Î·×»»¤Ë¥æ¥ê¥¦¥¹Æü¤ò»È¤Ã¤Æ¤¤¤Þ¤¹¡£ ¤³¤ì¤Ï¡¢µª¸µÁ°4,713ǯ¤«¤é̤Íè¤Þ¤Ç¤ÎÁ´¤Æ¤ÎÆüÉÕ¤ò¡¢1ǯ¤Ï365.2425Æü¤Ç¤¢¤ë¤È²¾ÄꤷÀµ³Î¤Êͽ¬¤ä·×»»¤ò¤¹¤ë¤È¤¤¤¦Í¥¤ì¤¿ÆÃÀ¤ò»ý¤Ã¤Æ¤¤¤Þ¤¹¡£
19À¤µª°ÊÁ°¤ÎÆüÉÕµ¬Â§¤Ï¤ª¤â¤·¤í¤¤Æɤßʪ¤Ë¤Ï¤Ê¤ê¤Þ¤¹¤¬¡¢ÆüÉÕ/»þ¹ï¥Ï¥ó¥É¥é¤ÎÀµ¤·¤¤¥³¡¼¥Ç¥£¥ó¥°¤òÊݾڤ¹¤ë¤³¤È¤ÏÀ°¹çÀ¤Ë¤Ä¤¤¤Æ´°àú¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¡£
| Á°¤Î¥Ú¡¼¥¸ | ¥Û¡¼¥à | ¼¡¤Î¥Ú¡¼¥¸ |
| ¥Ð¥¤¥Ê¥êÎó¥Ç¡¼¥¿·¿ | ¾å¤ËÌá¤ë | ÏÀÍýÃͥǡ¼¥¿·¿ |