Re: Calendar vs. Timestamp

> > I would like to clarify one observation. The timestamp seems only
> > take the date section data of a calendar object regardless the
> > value of the time zone. If so, a calendar object with a specified
> > time zone would not make any difference in comparsion to a
> > calendar object with the default time zone. Or, the default time
> > zone is always used in PG.
> >
>
> I think the confusion arises from the fact that the server always
> stores timestamps in utc and always returns them based upon the
> current setting of the TimeZone configuration parameter.
>
> CREATE TABLE tstest(a timestamptz);
> INSERT INTO tstest VALUES ('2006-04-11 16:15:28-07');
> INSERT INTO tstest VALUES ('2006-04-11 16:15:28-08');
> SET TimeZone = 'America/Los_Angeles';
> INSERT INTO tstest VALUES ('2006-04-11 16:15:28');
> SELECT * FROM tstest;

2006-04-11 16:15:28-07
2006-04-11 17:15:28-07
2006-04-11 16:15:28-07

> SET TimeZone = 'America/New_York';
> INSERT INTO tstest VALUES ('2006-04-11 16:15:28');
> SELECT * FROM tstest;
>

2006-04-11 19:15:28-04
2006-04-11 20:15:28-04
2006-04-11 19:15:28-04
2006-04-11 16:15:28-04

>

Thanks for the test code to clarify the time zone matter. I need to change my approach to show the date & time with the users' time zones.

--
_______________________________________________

Search for businesses by name, location, or phone number. -Lycos Yellow Pages

http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10