Then he works his way westward, as the next midnight happens, soon reaching the Philippines. Early in Santa’s day he visits Auckland NZ just after midnight, as that is one of the earliest midnights on the globe. To record the fact that Christmas starts after midnight on December 25 this year, we need to say 00:00:00 without any time zone. Table: holiday_Ĭolumn: start_ Type: TIMESTAMP WITHOUT TIME ZONE Ex: Christmasįor example, say you need to record the start of holidays/holy days. They have no real meaning until you apply a time zone or offset-from-UTC. They represent a rough idea about potential moments, possible points on the timeline along a range of about 26-27 hours (the range of time zones around the globe). TIMESTAMP WITHOUT TIME ZONE values are not a point on the timeline, not actual moments.
0 Comments
Leave a Reply. |