Hello,
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
select '2010-12-09 22:00:00' at time zone 'MSK'
one-# ;
ÂÂÂÂÂ timezoneÂÂÂÂÂÂ
---------------------
Â2010-12-10 01:00:00
(1 row)
select '2010-12-09 02:00:00' at time zone 'PST';
ÂÂÂÂÂ timezoneÂÂÂÂÂÂ
---------------------
Â2010-12-08 18:00:00
(1 row)
how can I do this using only dow and time?
Thank you.
