RES: Datetime problem

Hello,

- PostgreSQL 7.3.2 on i386-redhat-linux GCC 3.2.2
- Timezone: Brazil (GMT-3, I think).

I think my problem is with the time zone. Using a SET TIME ZONE GMT, the
result is Ok. But I don't know how to work with time zones correctly.

When I send a date to to_timestamp, pgsql thinks this date is in GMT?

Thanks for all your help.


[]'s

Eric Lemes

> -----Mensagem original-----
> De: pgsql-sql-owner@postgresql.org
> [mailto:pgsql-sql-owner@postgresql.org]Em nome de Tom Lane
> Enviada em: segunda-feira, 14 de junho de 2004 11:56
> Para: Eric Lemes
> Cc: pgsql-sql@postgresql.org
> Assunto: Re: [SQL] Datetime problem
> 
> 
> "Eric Lemes" <eric.lemes@zanthus.com.br> writes:
> > - select to_timestamp('2004 10 10 00 00 00', 'YYYY MM DD HH MI SS')
> > the output is:
> > - 2004-10-09 23:00:00-03
> 
> What PG version is this, on what platform, and what's your current
> timezone setting?
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004
> 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.693 / Virus Database: 454 - Release Date: 31/5/2004