¹ØÓÚoracleµÄtimestamp with time zoneµÄÎÊÌâ

ÔÚoracleµÄ¡°Oracle® Database Globalization Support Guide¡±ÎĵµÖÐ

ÓйØtimestamp with timezoneµÄÃèÊöÈÃÎÒÎÞ·¨Àí½â¡£

Two TIMESTAMP WITH TIME ZONE values are considered identical if they represent the same instant in UTC, regardless of the TIME ZONE offsets stored in the data. For example, the following expressions have the same value:

TIMESTAMP '1999-01-15 8:00:00 -8:00'
TIMESTAMP '1999-01-15 11:00:00 -5:00'

-----------
TIMESTAMP '1999-01-15 8:00:00 -8:00'
TIMESTAMP '1999-01-15 11:00:00 -5:00'
-----------

ÕâÁ½¸öÊý¾ÝµÄutc instanceʱ¼äÊǶàÉÙ£¿
TIMESTAMP '1999-01-15 8:00:00 -8:00'——¡·utc time"1999-01-15 0:00:00"
TIMESTAMP '1999-01-15 11:00:00 -5:00'——¡·utc time"1999-01-15 6:00:00"
»¹ÊÇÆäËû£¿

ÔõôµÃ³ö¡°the following expressions have the same value¡±Õâ¸ö½áÂ۵ģ¿

---

Èç¹ûÊÇ
TIMESTAMP '1999-01-15 8:00:00 -8:00'——¡·utc time"1999-01-15 16:00:00"
TIMESTAMP '1999-01-15 11:00:00 -5:00'——¡·utc time"1999-01-15 16:00:00"

µÄ»°¾ÍÊÇÏàͬµÄÁË£¿Ó¦¸ÃÊÇÈç´Ë°É¡£

---

ÒýÓÃ

ÒýÓà 1 Â¥ calmer_j µÄ»Ø¸´:
Èç¹ûÊÇ
TIMESTAMP '1999-01-15 8:00:00 -8:00'——¡·utc time"1999-01-15 16:00:00"
TIMESTAMP '1