Re: Timestamp with time zone

Le 30.06.2010 18:59, Tim Landscheidt a écrit :
> Xavier Robin <xavier.robin@bluewin.ch> wrote:
>> Just one more question to make sure I got it all right:
>
>> EXTRACT(timezone FROM <a timestamptz here>)
>
>> will *always* return 0? Because the doc suggests that positive or
>> negative values can be returned…
>
> No, it will return the offset of your current time zone:

I got it, thanks a lot! :)
So WITH TIME ZONE was not at all what I expected (thought it would store
the time zone of the timestamp entered). I'll see if switching to
TIMESTAMP WITHOUT TIME ZONE is what I need now.

Thanks all for your answers and insights.

Xavier