o de 2006 14:00
Para: [EMAIL PROTECTED]; Postgres general mailing list
Assunto: RE: [GENERAL] RESTORING A DATABASE WITH DIFFERENT TIMEZONES
'2006-12-20 00:00:00-02' and '2006-12-19 23:00:00-03' *are* the same
time. You *did* preserve it. Is your application unaware of timezone?
If
On Dec 21, 2006, at 11:32 , Rodrigo Sakai wrote:
But I have to restore it and maintain the same value of datetime!
How can I do it?
You should have no problem. A timestamp with time zone marks an
absolute instant in time: the different time zones are different
representations of the s
'2006-12-20 00:00:00-02' and '2006-12-19 23:00:00-03' *are* the same
time. You *did* preserve it. Is your application unaware of timezone?
If you want the server to behave like it's in a different time zone that
where it actually is, configure the locale in postgresql.conf.
http://www.postgresq
