Re: Timestamp with time zone

(copy to the list)
Le 30.06.2010 16:25, Tim Landscheidt a écrit :
> So if you need the timezone information, you'll have to re-
> cord it separately.

Oh, I was thinking about that, but it sounded weird because it was what
I was expecting from a TIMESTAMP WITH*OUT* TIME ZONE column.

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…
And (just 1 more) so what's the point of this field in the first place?

> IMVHO best practice is to treat TIMESTAMP WITH TIME ZONE
> as truly evil (TM), only use UTC timestamps in the database
> and only convert them from and to something timezonic in
> your application when it has to interact with a human being.

I'll try to keep that in mind!

Thanks,
Xavier