* Tom Lane:
> Florian Weimer <[EMAIL PROTECTED]> writes:
>> * Agent M.:
>>> timestamp with time zone does not record the timezone you inserted it
>>> with- it simply stores the GMT version and converts to whatever
>>> timezone you like on demand.
>
>> Are you sure? This behavior is not documented
Florian Weimer <[EMAIL PROTECTED]> writes:
> * Agent M.:
>> timestamp with time zone does not record the timezone you inserted it
>> with- it simply stores the GMT version and converts to whatever
>> timezone you like on demand.
> Are you sure? This behavior is not documented, and I can't reprodu
Thanks for the replies, and thanks for mentioning the DST thing.
So, i'm going to use tstz. I just don't want my data to be affected by
timezone changes and dst etc.
I had a game server which had a timer system, when i delay something it
was creating an object with timestamp "now + delaytime" and
On Thu, Jul 13, 2006 at 04:35:20PM -0700, Antimon wrote:
> Hi,
> I'm working on a web project with pgsql, i did use mysql before and
> stored epoch in database so i'm not familiar with these datatypes.
>
> What i wanna ask is, if i don't need to display timestamps in different
> timezones, shall i
* Agent M.:
> timestamp with time zone does not record the timezone you inserted it
> with- it simply stores the GMT version and converts to whatever
> timezone you like on demand.
Are you sure? This behavior is not documented, and I can't reproduce
it with PostgresQL 8.1.4.
--
Florian Weimer
On Jul 13, 2006, at 21:49 , Agent M wrote:
For example, flight arrival information should probably include the
timezone of the destination.
Of course, for this example you'd also want to know *where* the
flight is arriving, which would also let you know the appropriate
time zone in an in
But watch out! This is mentioned in the docs but it bit me when I used
timestamp with time zone so:
timestamp with time zone does not record the timezone you inserted it
with- it simply stores the GMT version and converts to whatever
timezone you like on demand. If the timezone is important da
On Thu, Jul 13, 2006 at 04:35:20PM -0700, Antimon wrote:
> Hi,
> I'm working on a web project with pgsql, i did use mysql before and
> stored epoch in database so i'm not familiar with these datatypes.
>
> What i wanna ask is, if i don't need to display timestamps in
> different timezones,
Not th
Hi,
I'm working on a web project with pgsql, i did use mysql before and
stored epoch in database so i'm not familiar with these datatypes.
What i wanna ask is, if i don't need to display timestamps in different
timezones, shall i use timestamptz anyway? I mean, i'm gonna need
timestamp columns on