Sorry if I have posted this to the wrong mailing list. Its my first post.
I have a problem that I hope someone can help me with.
I have inherited a postgresql DB which has a table containing a day of the week, a time and a time zone. I need to translate all these times into UCT but I need to keep track of which day of the week the new time relates to.
e.g. this 2 timestamps go to different days
one=# select '2010-12-09 22:00:00' at time zone 'MSK' one-# ; timezone --------------------- 2010-12-10 01:00:00 (1 row)
one=# select '2010-12-09 02:00:00' at time zone 'PST'; timezone --------------------- 2010-12-08 18:00:00 (1 row)
